| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reverse y-axis, with maximum number at x-axis | Charts and Charting in Excel | |||
| Excel 2002/2003 problem | Excel Discussion (Misc queries) | |||
| Problem w/X axis in chart (2003) | Charts and Charting in Excel | |||
| Secondary X-axis with reverse Y-axis | Charts and Charting in Excel | |||
| Excel 2002 to 2003 problem | Excel Programming | |||
Threaded Mode
