Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 7th 05, 06:45 PM
wendythelwell
 
Posts: n/a
Default Chaning X axis scale in Excel 2003


I am having problems with changing the scale on for example a bar chart
x axis. When I double click the axis to bring up the Formax Axis menu
the options to change the scale under the scale tab are not the same as
the Y axis as the min and max options etc are not available. Has anyone
else come across this problem and does anyone know how to change the
scale and set the min and max options.


--
wendythelwell
------------------------------------------------------------------------
wendythelwell's Profile: http://www.excelforum.com/member.php...o&userid=26012
View this thread: http://www.excelforum.com/showthread...hreadid=393691


  #2   Report Post  
Old August 8th 05, 02:28 AM
Jon Peltier
 
Posts: n/a
Default

In a column chart, the X axis is a category axis. The category labels
are just that, text labels, interpreted without numerical value (even if
they look like numbers to you and me). Therefore, no minimum or maximum.
You can sometimes trick Excel by changing it to a time scale axis (Chart
menu Chart Options Axes tab). This interprets numbers as dates,
starting with 1 as January 1, 1900. If you change the number format of
the axis to General or something similar, you will see the numerical
values, you'll be able to assign beginning and ending dates (just enter
the numbers you want if Excel insists on displaying dates), and the axis
might behave the way you want. Keep in mind that the columns will now
become limited in width to the space between individually numbered
categories.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


wendythelwell wrote:

I am having problems with changing the scale on for example a bar chart
x axis. When I double click the axis to bring up the Formax Axis menu
the options to change the scale under the scale tab are not the same as
the Y axis as the min and max options etc are not available. Has anyone
else come across this problem and does anyone know how to change the
scale and set the min and max options.


  #3   Report Post  
Old August 9th 05, 02:35 PM
wendythelwell
 
Posts: n/a
Default


Hi Jon

Many thanks for your reply. However, what is further confusing is that
seems to work OK on earlier versions of Excel but just not on 2003.
However, the good news is that changing the dates - as they were dates
on the spreadsheet - to Time scale works so many thanks. I will check
with an earlier version of Excel so see if it automatically selected
Time scale.

Wendy


--
wendythelwell
------------------------------------------------------------------------
wendythelwell's Profile: http://www.excelforum.com/member.php...o&userid=26012
View this thread: http://www.excelforum.com/showthread...hreadid=393691



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 crashes loading excel files created Excel 2000 Jeff Lewin Australia Excel Discussion (Misc queries) 0 June 27th 05 04:20 AM
Microsoft Excel 2003 and Hyperion Retrieve with Excel 2000. Juan Angel Excel Discussion (Misc queries) 1 June 21st 05 09:55 PM
External Links on open and Excel 2003 Guardian Excel Discussion (Misc queries) 3 June 16th 05 12:25 AM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 08:27 PM
how to increase maximum number of columns in excel 2003 [email protected] Excel Discussion (Misc queries) 1 January 16th 05 09:13 PM


All times are GMT +1. The time now is 08:26 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017