Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Joey041
 
Posts: n/a
Default Formatting X and Y axis'

Is there someway of getting the scale option that allows for minimum and
maximum on both the X and Y axis?

Right now, the option is only on the X and the Y scale wants to know where
to cross.
--
Very Thankful
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Joey -

You can set the min and max of the axes without worrying about where
they cross. Double click an axis, and on the Scale tab enter whatever
values you want. Then don't check the Auto boxes, because that tells
Excel to override your values and use its own automatically determined
defaults.

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

Joey041 wrote:

Is there someway of getting the scale option that allows for minimum and
maximum on both the X and Y axis?

Right now, the option is only on the X and the Y scale wants to know where
to cross.

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
Formatting X Axis Source Data Nate Carruthers Charts and Charting in Excel 1 February 8th 05 07:40 PM
Formatting dates on x axis of chart...! saturnin02 Excel Discussion (Misc queries) 4 January 27th 05 08:55 PM
Formatting of x axis Charles Excel Discussion (Misc queries) 2 January 14th 05 01:03 PM
space between y axis and data points.. Dave R. Charts and Charting in Excel 3 January 8th 05 04:56 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM


All times are GMT +1. The time now is 06:45 PM.

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

About Us

"It's about Microsoft Excel"