1
Answer

Group sql query result in MS Chart

Marius Vasile

Marius Vasile
Oct 20
260
1

I want to display in a chart, total values for 2 years grouped by month. What I tried is

var sampleData = new List<Sample> {
 new Sample { Month = "Ianuarie", Value = Convert.ToInt32(row["M1"]) },
 new Sample { Month = "Ianuarie", Value = Convert.ToInt32(row["L1"]) },
 new Sample { Month = "Februarie", Value = Convert.ToInt32(row["M2"]) },
 new Sample { Month = "Februarie", Value = Convert.ToInt32(row["L2"]) },
 new Sample { Month = "Martie", Value = Convert.ToInt32(row["M3"]) },
 new Sample { Month = "Martie", Value = Convert.ToInt32(row["L3"]) },
 new Sample { Month = "Aprilie", Value = Convert.ToInt32(row["M4"]) },
 new Sample { Month = "Aprilie", Value = Convert.ToInt32(row["L4"]) },
 new Sample { Month = "Mai", Value = Convert.ToInt32(row["M5"]) },
 new Sample { Month = "Mai", Value = Convert.ToInt32(row["L5"]) },
 new Sample { Month = "Iunie", Value = Convert.ToInt32(row["M6"]) },
 new Sample { Month = "Iunie", Value = Convert.ToInt32(row["L6"]) },
 new Sample { Month = "Iulie", Value = Convert.ToInt32(row["M7"]) },
 new Sample { Month = "Iulie", Value = Convert.ToInt32(row["L7"]) },
 new Sample { Month = "August", Value = Convert.ToInt32(row["M8"]) },
 new Sample { Month = "August", Value = Convert.ToInt32(row["L8"]) },
 new Sample { Month = "Septembrie", Value = Convert.ToInt32(row["M9"]) },
 new Sample { Month = "Septembrie", Value = Convert.ToInt32(row["L9"]) },
 new Sample { Month = "Octombrie", Value = Convert.ToInt32(row["M10"]) },
 new Sample { Month = "Octombrie", Value = Convert.ToInt32(row["L10"]) },
 new Sample { Month = "Noiembrie", Value = Convert.ToInt32(row["M11"]) },
 new Sample { Month = "Noiembrie", Value = Convert.ToInt32(row["L11"]) },
 new Sample { Month = "Decembrie", Value = Convert.ToInt32(row["M12"]) },
 new Sample { Month = "Decembrie", Value = Convert.ToInt32(row["L12"]) },
 };

// data bind

Chart1.DataBindCrossTable(sampleData, "Month", "Month", "Value", "Label=Month");

but the chart looks ugly. How do I make the XAxys show months, YAxis show counts in a month each year?

Answers (1)
Next Recommended Forum