I have a stored procedure that selects two columns from a single table - size (int) and date. All I want to do is plot a line graph with the size, and have the X axis item labels show the dates recorded.
So, the data looks like this:
And this is what I ended up with when I tried to use the Wizard (bound to a SqlDataSource):
What I want is to have the dates as the X axis labels, but I can't figure out how to do it. It seems like this should be incredibly simple, but I just find the chart syntax really confusing. Any help would be very much appreciated.
So, the data looks like this:
size | date |
224 | 1-5-10 |
250 | 1-10-10 |
156 | 1-22-10 |
And this is what I ended up with when I tried to use the Wizard (bound to a SqlDataSource):
<telerik:RadChart ID="RadChart1" runat="server" DataSourceID="SqlDataSource1" |
DefaultType="Line" Skin="Default"> |
<Series> |
<telerik:ChartSeries Name="Size" DataYColumn="size" Type="Line" |
DataXColumn="size"> |
<Appearance> |
<FillStyle MainColor="213, 247, 255"> |
</FillStyle> |
</Appearance> |
</telerik:ChartSeries> |
</Series> |
<PlotArea> |
<XAxis AutoScale="False" DataLabelsColumn="size"> |
</XAxis> |
</PlotArea> |
</telerik:RadChart> |
What I want is to have the dates as the X axis labels, but I can't figure out how to do it. It seems like this should be incredibly simple, but I just find the chart syntax really confusing. Any help would be very much appreciated.