Can a value axis autoscale to something other than 0 for the min?

[Guest]

I know how to manually change the scale on a value axis, but is there a way
to have the autoscale function automatically maximize the data in the chart?
This is for a dynamic chart that can change when certain selection items are
chosen from drop-down menus.

For example, one set of data ranges from 6 to 9, so I would want the scale
to be 5 to 10. Then, the selections change, and the data displayed in the
chart now ranges from 31 to 39. I want the scale to be 30 to 40, not 0 to 40.

Can this be done?

 

[Jon Peltier]

Unfortunately, Excel's axis autoscale algorithms do not suit your (or my)
preferences. The minimum scale will only NOT be zero if the data spans
positive and negative numbers, or if the minimum is greater than (about) 65%
of the maximum.

If you can write your own algorithms to calculate axis limits, you can put
these formulas into worksheet cells, then use VBA to link the axis to these
cells, using this technique:

http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

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

 

[mastgoo]

Help on MIN

Hi.

What would be the formula to use if you have a series of numbers (+/-) and you have to get the MIN from the series that is greater than zero. Ex, 45, 5, -6. MIN should be 5. How do i do that? Tnx