This is a migrated thread and some comments may be shown as answers.

what's the best way to chart this in rad chart?

1 Answer 53 Views
Chart (Obsolete)
This is a migrated thread and some comments may be shown as answers.
SelAromDotNet
Top achievements
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!

1 Answer, 1 is accepted

Sort by
0
Ves
Telerik team
answered on 10 Jul 2008, 07:30 AM
Hi SelArom,

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".
I have attached an example. Hope this helps.

Best wishes,
Ves
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center
Tags
Chart (Obsolete)
Asked by
SelAromDotNet
Top achievements
Rank 2
Answers by
Ves
Telerik team
Share this question
or