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

Thread is closed for posting
2 posts, 0 answers
  1. SelAromDotNet
    SelAromDotNet avatar
    67 posts
    Member since:
    Jul 2012

    Posted 09 Jul 2008 Link to this post

    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?

  2. Ves
    Ves avatar
    2914 posts

    Posted 10 Jul 2008 Link to this post

    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,
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
Back to Top