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?