View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TFriis TFriis is offline
external usenet poster
 
Posts: 22
Default 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