Chart do not work with date

[Paulo]

I have a range of dates. My chart needs to start on a certain date, but is beginning on the first date of the Xaxis. How do I get in a certain specific date?

[Petar Kirov]

Hi Paulo,

The ASP.NET RadChart uses the OADate format to visualize DateTime data. This means that in order to set a manual X axis range, you will need to convert DateTime values to OADate first: 

double startDateInOA = new DateTime(2013, 1, 1).ToOADate();
double endDateInOA = new DateTime(2013, 5, 1).ToOADate();
double step = 1; // one day in OADate format

radChart.PlotArea.XAxis.AutoScale = false;
radChart.PlotArea.XAxis.AddRange(startDateInOA, endDateInOA, step);

Additionally to make the RadChart visualize the X axis labels in DateTime format, you can set the Value format of the axis to one of the DateTime options: 

radChart.PlotArea.YAxis.Appearance.ValueFormat =
    Telerik.Charting.Styles.ChartValueFormat.ShortDate;

By default the RadChart's axes are zero based. This means when AutoScale is true, the first date displayed will be 0.0 which in OADate format is 30 Dec 1899. To change that, you can set radChart.PlotArea.XAxis.IsZeroBased to false.

I hope this helps.

Regards,
Petar Kirov
the Telerik team