Y Axis

[ATL_Scott]

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?

[Jon Peltier]

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" <[email protected]> wrote in message
news:[email protected]...
>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?