Reverse axis problem between 2002 & 2003
 

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

Reverse axis problem between 2002 & 2003
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"TFriis" wrote in message
...
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