LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
nospaminlich
 
Posts: n/a
Default Setting rules for y scale

I've set the scale to Max 1000 which is fine most of the time but very
occasionally there will be a value of more than 1000 and for these instances
I need the scale to automatically rescale.

Is it possible to set the Y scale of a graph to Max 1000 but if the data
exceeds 1000 then revert the scale to Auto? If so, how do I do this?

Many thanks




 
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
2 scale in a single chart dom Charts and Charting in Excel 1 March 4th 06 02:48 PM
Changing the scale major unit in a graph Ant Excel Discussion (Misc queries) 2 February 6th 06 01:42 PM
Setting round numbers for the scale Mangesh Yadav Charts and Charting in Excel 2 September 10th 05 06:07 AM
Setting x axis scale to time with variable intervals webbuzzard Charts and Charting in Excel 1 June 27th 05 07:13 PM
Calculation Setting in Excel Stuart Bisset Excel Discussion (Misc queries) 0 June 17th 05 09:54 AM


All times are GMT +1. The time now is 08:52 AM.

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

About Us

"It's about Microsoft Excel"