Steema Central

When producing a time series chart, the origin of the X axis (time) is not always labeled. I would like to see the first label always be placed at the origin and then subsequent labels be placed using the Desired Tick Increment. This issue is most apparent when producing charts with one month of data or more. If you are using 2 day increments for June, then the 1st is labeled because there are 30 days in June. However, if you use 2 day increments for July (31 days), then the first tick label appears on the 2nd. (I am setting the minimum value to 7/1/2004 and the maximum to 8/1/2004.) I can adjust the maximum to 7/31/2004 12:59:59 PM to get a label on the 1st but then June would not work unless I adjust the date back to midnight.

Thanks for considering this and my previous two posts!

Hi,

When producing a time series chart, the origin of the X axis (time) is not always labeled.

Does the IAxisLabels.OnAxis property (see Help for details) remedy the problem for you?

No, the OnAxis property does not seem to fix the problem. You can try this:

Create a chart with 1 month of hourly data starting on 5/1/2004 and ending on 6/1/2004. Then, set the tick increment of the time axis (bottom axis) to 1 week.

In most cases I see the last point labeled and the labels appear to work backwards in 1 week intervals which results in either the 3rd or the 4th being the first label (left most) depending on the number days in the month. I would prefer that the 1st be labeled followed by the 8th, 15th, ...

Is there anyway to force this behavior?