One easy trick is to have another column next to the Y values, and insert a
formula which essentially subtracts the minimum Y value from each cell in
this column. Make the chart with this data, and you're going to show the
relative, not absolute, values. The data will fill most of the Y scale.

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


"ATL_Scott" wrote in message
...
I have a set of charts that I use that I copy and paste external data into
the sheet to look at the graph it creates. The problem I have is the y
scale
makes the line too flat. While I know I can override the scale the
problem
is I am pasting 40 different sets of data in one after another so to reset
the scale each time is too time consuming. Can I keep the scale set on
auto
but not have it go down to zero all the time?