Automatically Adjust The Scale on the Y-Axis?

[MDW]

I'm trying to chart several series of data. The user will be able to select
one day from a dropdown, and all the data from that particular day will
display in a table. I know that the number of data points will always be the
same. I want to then chart the results.

Problem is, the values to be charted vary in size. Sometimes the values are
between 6 and 7, other times they're between 8 and 10. In general, the data
varies by as little as 0.030 between data points. If I make the Y-axis scale
wide enough to accomodate all possible values, the chart will lose all
meaning.

Is there a way I can have the y-axis modulate itself so that the min value
is the smallest value being charted, and the max is the highest value?

I'm using Excel 2003.

TIA

 

[David Biddulph]

It will auto-scale by default. Format/ axis/ scale and put the tick marks
back in against the min and max.

 

[John Mansfield]

You can automatically link the maximum and minimum values in your chart to
cells via the VBA procedure that Jon Peltier has described below. This
process will give you complete control over what data appears on your Y-axis.

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