What you need to do then is write some formulas that determine reasonable
values for min, max, and major unit. Use these cells in the macro that
adjusts the chart.

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


"hlmrspd" wrote in message
...
I've used that technique on the X axis (time) and it works great however,
the
spreadsheet is being used as a template and I am putting in wide
variations
of data for the Y axis. I have been adjusting the y axis manually on 50
charts everytime I do another data run. For instance one of the charts
auto
scales 0 lbm/hr to 120,000 lbm/hr but all of the data is between 100,000
and
107,000. The next scenario I run the data is betwwen 40,000 and 46,000. So
I
need the charts to auto scale to 10 - 20 percent outside of the range
everytime I do a run.

"Jon Peltier" wrote:

Calculate the appropriate values in some cells. Use this technique to
apply
the calculated values to the chart's axis:

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

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


"hlmrspd" wrote in message
...
I have a spread sheet with numerous charts. I need the y axis on the
charts
to set the minimum appoximately 20% below the lowest data point and set
the
maximum appoximately 20% above the highest data point. The major unit
should
be set at appoximately 10% of the entire range of data. The
spreadsheets
are
templates and will have a wide variety data placed into the cells.