Reverse axis problem between 2002 & 2003

T

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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

why Excel freezes when you change axis scale? 1
Excel 2003, graph y axis labelling problem 1
Chart axis labels appear black with small vertical fonts 0
Access 2003 transfer between databases blocked 1
VBA presentations.InsertFromFile broken under Office 2003 SP3 1
Why do some Word 2003 prompt for running a blank SQL command? 2
Problems getting outlook 2002 to work with migrated Exchange 2007 (from 2003) 0
Problem Upgrading from 2002 to 2003 4

Top