Thread: [SOLVED] Can a value axis autoscale to something other than 0 for the min?

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?

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/...nkToSheet.html

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

"jthimagesolutions" <jthimagesolutions@discussions.microsoft.com> wrote in
message news:8DC878EB-AF7C-4651-B597-3A6E24FA3326@microsoft.com...
>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?