I have chart with some values as shown on the picture. I want X label value to be project name, but now I have data in series and on x i have (1) not the project name. so How to force X values to bound the project name from database Programmatically ?
heres my code:
ChartSeries series1 = new ChartSeries("Estimated Hours", ChartSeriesType.Bar);
ChartSeries series2 = new ChartSeries("Actual Hours", ChartSeriesType.Bar);
ChartSeries series3 = new ChartSeries("Variance", ChartSeriesType.Bar);
foreach (DataRow dtrow in dt.Rows)
{
series1.Items.Add(new ChartSeriesItem(Convert.ToDouble(dtrow["estimated_total"]), dtrow["estimated_total"].ToString()));
series2.Items.Add(new ChartSeriesItem(Convert.ToDouble(dtrow["actual_total"]), dtrow["actual_total"].ToString()));
series3.Items.Add(new ChartSeriesItem(Convert.ToDouble(dtrow["variance_total"]), dtrow["variance_total"].ToString()));
}
RadChart1.Series.Clear();
RadChart1.Series.Add(series1);
RadChart1.Series.Add(series2);
RadChart1.Series.Add(series3);
heres my code:
ChartSeries series1 = new ChartSeries("Estimated Hours", ChartSeriesType.Bar);
ChartSeries series2 = new ChartSeries("Actual Hours", ChartSeriesType.Bar);
ChartSeries series3 = new ChartSeries("Variance", ChartSeriesType.Bar);
foreach (DataRow dtrow in dt.Rows)
{
series1.Items.Add(new ChartSeriesItem(Convert.ToDouble(dtrow["estimated_total"]), dtrow["estimated_total"].ToString()));
series2.Items.Add(new ChartSeriesItem(Convert.ToDouble(dtrow["actual_total"]), dtrow["actual_total"].ToString()));
series3.Items.Add(new ChartSeriesItem(Convert.ToDouble(dtrow["variance_total"]), dtrow["variance_total"].ToString()));
}
RadChart1.Series.Clear();
RadChart1.Series.Add(series1);
RadChart1.Series.Add(series2);
RadChart1.Series.Add(series3);