I have a line chart that is popuated by
this
.dataSet1 = Query;this.LineChart.DataSource = this.dataSet1;this.LineChart.DataBind();
The query returns :
2010/01/09 62010/01/09 42010/01/09 3
The chart shows a different point for each row i.e 3 points of values 6, 4 and 3, when what I want is for the data to be grouped by date so that I get one point of value 13.
Is there a property of the chart or something else which would allow me to do this easily ?
The query already contains a sum function so it is difficult to do the grouping there. I could write code to loop round the dataset and sum it myself but I was hoping to avoid it
Thanks John
Unfortunately, the line chart doesn't perform any grouping. Our scatter charts have grouping functionality, but even they won't sum up the values. You will have to loop through the dataset and add the values manually.