Terry:

You can set the X axis scale from -1 to 41 with a major interval of 5.
Format the X Axis to remove tick marks and X axis labels.

Then add a make a dummy X axis series that shows 0, 5, 10, etc.

See one of these posts for how-to information on adding dummy axis series.

http://processtrends.com/pg_charts_d...xis_series.htm

http://peltiertech.com/Excel/Charts/...tml#hdrDummies

Kelly




"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.