Unfortunately the invariant point is the axis minimum, so in order to have a
tick mark at zero, you have to cross axes at an integral number of major
units below zero. In other words, min = -5, major unit = 5, axis crosses
at -5, etc.

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


"Terry" wrote in message
...
I have a question similar to IgorM (6/22/2006) posted, I think.

In simple way describe:
We have a XY (scatter) chart with lines connect points.
Our X axis scale is 0 to 40 with major unit of 5.
Since there is several data point at 0 of X axis, we would like to move Y
axis cross at -1 of X axis (in Excel default Y axis cross at 0 of X axis).

So how do we shift Y axis to -1 of X axis still keep X axis scale of 0 to
40
and not showing -1 of X axis.