Hello all,
I'm trying to chart some data and I'm having trouble getting the points to plot in the correct order with AutoRange, so I'm trying to set the X Axis Range myself.
I'm using a Date value as the X Data Points, and I've almost got it working correctly, except I can't get the Step size correct. I want the step to be 1 Month, but unfortunately there doesn't seem to be a way to set a "month" as a step interval for the XAxis.Step property.
If I try to set the step to 31 days, I get the behavior shown in the 31DaysStep screenshot (see attached). Basically I get months shown redundantly. If I try to do 32 day steps to overcomes this, the opposite behavior occurrs and the extra days between months start to add up quick, so that my labels don't line up with my dates (See 32DayStep screenshot).
Any idea what I can do in this situation? AutoRange is not an option because when I map multiple series, sometimes the 2nd or 3rd series will have datapoints that are in-between those of the 1st series and as a result the point will be plotted in the incorrect X-Value label.
Thanks for your help.
I'm trying to chart some data and I'm having trouble getting the points to plot in the correct order with AutoRange, so I'm trying to set the X Axis Range myself.
I'm using a Date value as the X Data Points, and I've almost got it working correctly, except I can't get the Step size correct. I want the step to be 1 Month, but unfortunately there doesn't seem to be a way to set a "month" as a step interval for the XAxis.Step property.
If I try to set the step to 31 days, I get the behavior shown in the 31DaysStep screenshot (see attached). Basically I get months shown redundantly. If I try to do 32 day steps to overcomes this, the opposite behavior occurrs and the extra days between months start to add up quick, so that my labels don't line up with my dates (See 32DayStep screenshot).
Any idea what I can do in this situation? AutoRange is not an option because when I map multiple series, sometimes the 2nd or 3rd series will have datapoints that are in-between those of the 1st series and as a result the point will be plotted in the incorrect X-Value label.
Thanks for your help.