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

"MDW" wrote in message
...
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
--
Hmm...they have the Internet on COMPUTERS now!