SelAromDotNet
Top achievements
Rank 2
Rank 2
SelAromDotNet
asked on 09 Jul 2008, 06:23 PM
I'm in the process of upgrading some charts to use radchart, and since i'm pretty new to it (just started today and i love it already) I'm looking for some advice that I haven't been able to find in the documentation...
we have some monthly data which is in the form of a table with the columns
month monthname yr value
which means a user might have data for the past 3 years in 36 rows, one for each month of the year. I want to be able to show three line graphs on one radchart, one for each year in a different color. I thought that I would need to make three separate queries, one for each year, but when I was playing with it, I noticed I could just grab all data and "group" it somehow... I couldn't quite get it to work right however... so eventually I did end up splitting it into three chartseries, but now I can't get the month names to show up at the bottom, instead of showing the monthname, it shows the numerical month 1 - 12. I initialized the chartseries items with the value and the monthname, but that doesn't seem to affect the x axis.
so I guess my question is this: can I make a three-line chart using one bulk grab of data like I wanted to?
and also: how do I change the x-axis to show the month names instead of the numerical representations?
thanks!
we have some monthly data which is in the form of a table with the columns
month monthname yr value
which means a user might have data for the past 3 years in 36 rows, one for each month of the year. I want to be able to show three line graphs on one radchart, one for each year in a different color. I thought that I would need to make three separate queries, one for each year, but when I was playing with it, I noticed I could just grab all data and "group" it somehow... I couldn't quite get it to work right however... so eventually I did end up splitting it into three chartseries, but now I can't get the month names to show up at the bottom, instead of showing the monthname, it shows the numerical month 1 - 12. I initialized the chartseries items with the value and the monthname, but that doesn't seem to affect the x axis.
so I guess my question is this: can I make a three-line chart using one bulk grab of data like I wanted to?
and also: how do I change the x-axis to show the month names instead of the numerical representations?
thanks!
1 Answer, 1 is accepted
0
Hi SelArom,
Onto your questions:
Best wishes,
Ves
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
Onto your questions:
- Set DataGroupColumn property to "Year". This will force the chart to produce different series for each distinct value in this column.
- Set RadChart1.PlotArea.XAxis.DataLabelsColumn to "MonthName".
Best wishes,
Ves
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center