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.

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.

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.

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.

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.