re-order X-Axis

[Li]

Hi,

I have a MVVM application that dynamic generating Charts base on database queries. There is case that we have seriesA(2005, 2006, 2007), seriesB(2005,2006, ...) and seriesC(1999,2000, 2001...2005,2006), since the chart series were set from A to C, the x-axis displayed out of order like '2005, 2006, 2007, 1999, 2000.

Is there a property that can set the chart to start from the earliest year(date) on x-axis ?

Thanks,

[Yavor]

Hello Li,

In this case, if the default behavior of the chart does not meet your requirements well, you can turn off the autosclaling of the XAxis, set the min and max values, as well as the step. This would allow more flexibility in this setup.
I hope that this is a feasible approach for you.

All the best,
Yavor
the Telerik team

[Li]

Thanks for your respones. I'm still having problem with having AutoRange=false, how should I set up the step, min, and max, labelStep?

1) if I have the below setting, I still got out of ordered AxisX  and lost the Y value;

DefaultLabelFormat =

 

"yyyy";
IsDateTime=true; AutoRange=false;
MinValue= new DateTime(1995, 1, 1).ToOADate();
MaxValue=new DateTime(DateTime.Today.Year, 12, 31).ToOADate();
Step=365;

2) Another dataset, I need to display as monthly,  
DefaultLabelFormat = "MM/dd/yyyy";
Step=30;

Thanks.

[Evgeni "Zammy" Petrov]

Hello Li,

 To get your data sorted on the X axis you should order your data by the value that you map on X axis.
The snipped  you have pasted seems to be correct, I do not see anything wrong with it.

As alternative solution, I would like to point you to this example: http://demos.telerik.com/silverlight/#Chart/DateTimeGrouping. This way you will not need to configure the X axis. Just provide the correct group descriptors and let RadChart do the rest. (The WPF example is similar)

Regards,
Evgeni "Zammy" Petrov
the Telerik team