Double click on the axis, go to the Scale tab, enter the values you want,
and clear the checkboxes.

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


"ryan" wrote in message
...
I want to show a progression of data, tracking towards reaching a
predetermined goal. Unfortunately, as I get closer to the desired goal,
my Y
axis values are changing every time I update the data, thereby making it
look
like I am not getting any closer to the desired goal.

Is it possible to lock in the Axis values, so that they do no autmatically
adjust to "fit" the data provided. Thx.