Dear All,
I would like to change the default legend "Series1, Series2.." with the proper values:
http://i67.tinypic.com/dr60c5.jpg
if (!Page.IsPostBack)
{
DataTable dt = GeCharttData();
LoadChartData(dt);
}
private void LoadChartData(DataTable initialDataSource)
{
for (int i = 1; i < initialDataSource.Columns.Count; i++)
{
Series series = new Series();
series.IsValueShownAsLabel = true;
foreach (DataRow dr in initialDataSource.Rows)
{
int y = (int)dr[i];
series.Points.AddXY(dr["Data"].ToString(), y);
series.ChartType = SeriesChartType.Column;
}
ChartStatus.Series.Add(series);
//series.Points[0].LegendText = "NySak";
//series.Points[1].LegendText = "UnderBehandling";
//series.Points[2].LegendText = "VenterSvar";
//series.Points[3].LegendText = "Til Overvaking";
//series.Points[4].LegendText = "FerdigBehandlet";
//series.Points[5].LegendText = "Klar til raad";
//series.Points[6].LegendText = "Oversendt til SSA";
//series.Points[7].LegendText = "Arkivert";
}
}
private DataTable GeCharttData()
{
DataTable dt = new DataTable();
dt.Columns.Add("Data", Type.GetType("System.String"));
dt.Columns.Add("NySak", Type.GetType("System.Int32"));
dt.Columns.Add("UnderBehandling", Type.GetType("System.Int32"));
dt.Columns.Add("VenterSvar", Type.GetType("System.Int32"));
dt.Columns.Add("Til Overvaking", Type.GetType("System.Int32"));
dt.Columns.Add("FerdigBehandlet", Type.GetType("System.Int32"));
dt.Columns.Add("Klar til raad", Type.GetType("System.Int32"));
dt.Columns.Add("Oversendt til SSA", Type.GetType("System.Int32"));
dt.Columns.Add("Arkivert", Type.GetType("System.Int32"));
DataRow dr1 = dt.NewRow();
dr1["Data"] = "2016";
dr1["NySak"] = 32; // Series 1
dr1["UnderBehandling"] = 45; // Series 2
dr1["VenterSvar"] = 60;
dr1["Til Overvaking"] = 32;
dr1["FerdigBehandlet"] = 45;
dr1["Klar til raad"] = 60;
dr1["Oversendt til SSA"] = 32;
dr1["Arkivert"] = 45;
dt.Rows.Add(dr1);
DataRow dr2 = dt.NewRow();
dr2["Data"] = "2017";
dr2["NySak"] = 12;
dr2["UnderBehandling"] = 35;
dr2["VenterSvar"] = 10;
dr2["Til Overvaking"] = 70;
dr2["FerdigBehandlet"] = 21;
dr2["Klar til raad"] = 44;
dr2["Oversendt til SSA"] = 10;
dr2["Arkivert"] = 45;
dt.Rows.Add(dr2);
ChartStatus.Legends["Default"].BorderWidth = 1;
ChartStatus.Legends["Default"].MaximumAutoSize = 100;
ChartStatus.Legends["Default"].BorderColor = System.Drawing.Color.Black;
// Add item column separator of type line
ChartStatus.Legends["Default"].ItemColumnSeparator = LegendSeparatorStyle.Line;
ChartStatus.Legends[0].Enabled = true;
// Set title
ChartStatus.Legends[0].Title = "Legend: BruddLos Status";
//ChartStatus.Series[0].LegendText = "NySak";
//ChartStatus.Series[1].LegendText = "UnderBehandling";
//ChartStatus.Series[2].LegendText = "VenterSvar";
//ChartStatus.Series[3].LegendText = "Til Overvaking";
//ChartStatus.Series[4].LegendText = "FerdigBehandlet";
//ChartStatus.Series[5].LegendText = "Klar til raad";
//ChartStatus.Series[6].LegendText = "Oversendt til SSA";
//ChartStatus.Series[7].LegendText = "Arkivert";
return dt;
}
I have tried the commented lines, but it does not work.
Any help will be very much appreciated