Gantt chart with two different value format types for x-axis and y-axis

[kiran]

Hi Telerik team,

is there any way to draw a gantt with x-axis (with value format is SHORTDATE) and y-axis (with value format SHORT TIME)?

if so please send me the sample code or approach to do the same.

Help is highly appreciated.

regards,
kiran

[Dwight]

Hello kiran,

Thanks for writing, here is an example demonstrating gantt chart with different date-time formats:
(see lines 17 and 24)

	public Form1()
	{
	InitializeComponent();
	}
	protected override void OnLoad(EventArgs e)
	{
	base.OnLoad(e);
	DateTime today = DateTime.Today;
	// Setup chart orientation
	this.radChart1.SeriesOrientation = ChartSeriesOrientation.Horizontal;
	// Setup XAxis
	this.radChart1.PlotArea.XAxis.IsZeroBased = false;
	this.radChart1.PlotArea.XAxis.Appearance.ValueFormat = Telerik.Charting.Styles.ChartValueFormat.ShortDate;
	this.radChart1.PlotArea.XAxis.AutoScale = false;
	this.radChart1.PlotArea.XAxis.AddRange(today.ToOADate(), today.AddDays(10).ToOADate(), 1);
	this.radChart1.PlotArea.XAxis.LayoutMode = Telerik.Charting.Styles.ChartAxisLayoutMode.Inside;
	// Setup YAxis
	this.radChart1.PlotArea.YAxis.IsZeroBased = false;
	this.radChart1.PlotArea.YAxis.Appearance.ValueFormat = Telerik.Charting.Styles.ChartValueFormat.ShortTime;
	this.radChart1.PlotArea.YAxis.AutoScale = false;
	this.radChart1.PlotArea.YAxis.AddRange(today.AddHours(7).ToOADate(), today.AddHours(18).ToOADate(), 1d / 24d);
	// Setup Series
	this.radChart1.Series[0].Type = ChartSeriesType.Gantt;
	this.radChart1.Series[0].DataXColumn = "X";
	this.radChart1.Series[0].DataXColumn2 = "X2";
	this.radChart1.Series[0].DataYColumn = "Y";
	this.radChart1.Series[0].DataYColumn2 = "Y2";
	// Data Bind
	this.radChart1.Series[0].Appearance.LabelAppearance.Visible = false;
	this.radChart1.DataSource = GenerateSource("Table");
	this.radChart1.DataMember = "Table";
	this.radChart1.DataBind();
	}
	private DataSet GenerateSource(string tableName)
	{
	double[,] input = new double[3, 2] {
	{ 8, 12 }, { 9, 14}, { 13, 18.5}
	};
	DataTable table = new DataTable(tableName);
	table.Columns.Add("X", typeof(double));
	table.Columns.Add("X2", typeof(double));
	table.Columns.Add("Y", typeof(double));
	table.Columns.Add("Y2", typeof(double));
	DateTime start = DateTime.Today;
	for (int i = 0; i < 3; i++)
	{
	DataRow row = table.NewRow();
	row["X"] = start.AddDays(i).ToOADate();
	row["X2"] = start.AddDays(i + 1).ToOADate();
	row["Y"] = start.AddHours(input[i, 0]).ToOADate();
	row["Y2"] = start.AddHours(input[i, 1]).ToOADate();
	table.Rows.Add(row);
	}
	DataSet dataSet = new DataSet();
	dataSet.Tables.Add(table);
	return dataSet;
	}

Should you have further questions, do not hesitate to contact me.

Regards,
Evtim
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center