Reverse axis problem between 2002 & 2003

[TFriis]

Hi I have a problem - testing my sheet (that automatically creates
charts with vba) in excel 2003 makes the xCategory on the charts
reverse for some reason - does anybody know why - and more importantly
know how to prevent this?

Data is like this

01.11.2008 10.000
01.10.2008 20.000
01.09.2008 30.000
01.08.2008 40.000
....

In 2002 the axis automatically starts 01.01.2008 -> 01.11.2008
In 2003 the axis goes from 01.11.2008 -> 01.01.2008

Thanks.

Nb: 2002 is 10.4524.4219 SP2
Nb: 2003 is 11.8169.8172 SP3

 

[Andy Pope]

Hi,

Make sure the axis is Categorical and not Time Series.

Right click chart and pick Chart Options > Axes > Category

You can record the code produced whilst performing that action if you need
to make the change within code.

Cheers
Andy