Then you have to set the min, max, and spacing that you want, hide the
"normal" axis labels, and use a helper series to apply (hidden) points and
data labels. For the labels, you can simply use the X values, so it's
simpler than the examples on my web site which require an additional label
range:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

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


"Terry" wrote in message
...
The problem is we don't want any addition X axis smaller than -1.
So, this will work but this is not the way we want.

The figure will be used on professional journal, it shout not have any
X-axis that from -5 to -1 if there is no data there.


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.