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      6
2010/01/09      4
2010/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