Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Setting rules for y scale
There is no way to do this without macros. (Well, no easy way, and it's a
full day advanced charting class to learn the hard way.) But you can link your axis parameters to worksheet cells using macros and worksheet events, as described he http://peltiertech.com/Excel/Charts/...nkToSheet.html Put a formula in the Ymax cell that does something like this: =IF(MAX(your_Y_value_range_here)1000,100*(INT(MAX (your_Y_value_range_here)/100)+1),1000) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "nospaminlich" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Setting rules for y scale
Thanks a lot Jon. I'll give the macro a try.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 scale in a single chart | Charts and Charting in Excel | |||
Changing the scale major unit in a graph | Excel Discussion (Misc queries) | |||
Setting round numbers for the scale | Charts and Charting in Excel | |||
Setting x axis scale to time with variable intervals | Charts and Charting in Excel | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) |