We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

(scatter plot) DateTime Xaxis min and max value

Thread ID:

Created:

Updated:

Platform:

Replies:

80504 Apr 7,2009 09:26 AM Apr 13,2009 03:40 AM Windows Forms 2
loading
Tags: Chart
Administrator [Syncfusion]
Asked On April 7, 2009 09:26 AM

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)


Administrator [Syncfusion]
Replied On April 7, 2009 06:48 PM

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)




Manimala S [Syncfusion]
Replied On April 13, 2009 03:40 AM

Hi,

That was great. Thanks for the update.

Thanks for using Syncfusion Products.

Thanks,
Manimala.




CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;