(scatter plot) DateTime Xaxis min and max value

I have a min date of Nov 26, 2014 I will have over 10,000 points that are exported directly from excel using xlsio into a datatable. I don't want to have to loop through each row and insert into a dataview to sort.

Ex. Essential chart starts the origin at 1/1/2013 because of this:
this.chartControl1.PrimaryXAxis.DateTimeRange = new ChartDateTimeRange(this.chartControl1.PrimaryXAxis.DateTimeRange.Start, this.chartControl1.PrimaryXAxis.DateTimeRange.End, 1, ChartDateTimeIntervalType.Years);

this.chartControl1.PrimaryXAxis.DateTimeRange.Start = "1/1/2013".

How do I get the this.chartControl1.PrimaryXAxis.DateTimeRange.Start = 3-6months from the data's min date (w/o having to manually obtain the data's min date)


2 Replies

AD Administrator Syncfusion Team April 7, 2009 10:48 PM UTC

Disregard,.. I figured out how to get the min and max from the datatable.

dateMin = (DateTime)xValues.Compute("Min(StartDate)", null) ;
dateMax = (DateTime)xValues.Compute("Max(StartDate)", null);

>I have a min date of Nov 26, 2014 I will have over 10,000 points that are exported directly from excel using xlsio into a datatable. I don't want to have to loop through each row and insert into a dataview to sort.

Ex. Essential chart starts the origin at 1/1/2013 because of this:
this.chartControl1.PrimaryXAxis.DateTimeRange = new ChartDateTimeRange(this.chartControl1.PrimaryXAxis.DateTimeRange.Start, this.chartControl1.PrimaryXAxis.DateTimeRange.End, 1, ChartDateTimeIntervalType.Years);

this.chartControl1.PrimaryXAxis.DateTimeRange.Start = "1/1/2013".

How do I get the this.chartControl1.PrimaryXAxis.DateTimeRange.Start = 3-6months from the data's min date (w/o having to manually obtain the data's min date)





MS Manimala S Syncfusion Team April 13, 2009 07:40 AM UTC

Hi,

That was great. Thanks for the update.

Thanks for using Syncfusion Products.

Thanks,
Manimala.




Loader.
Up arrow icon