Trouble With Line Graph

[Andrew]

I am trying to create a line graph for a report, and I am having a lot of trouble figuring out exactly how to do what I need. This is what my data looks like:

http://dl.dropbox.com/u/2978500/data.png

I want to be able to show sales averages for two different types of accounts over the past several years. The x axis should be the years, the y axis should be the dollar amount, and the account type should be the series.

I have set the chart's DataGroupColumn property to GroupID, and that correctly makes two series. However, the y axis is wrong, and I end up with this:

http://dl.dropbox.com/u/2978500/chart.png

How do I get the months across the y axis?

[Peter]

Hello Andrew,

Currently the Chart item doesn't support out of the box grouping. However, we do work on improving the chart item so that it can handle such scenarios, but currently we can't engage with a time frame. In the meantime as a workaround our suggestion is to group and aggregate your data appropriately in SQL query and if necessary utilize Pivot and Unpivot to rotate the table values and have only one column per chart series.

Please excuse us for the temporary inconvenience.

All the best,
Peter
the Telerik team