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.

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.

I tried before I send this.
When Y axis cresses at smaller than minimum, nothing happens.

By the way we don't want anything smaller than 0 show up at X axis.


It's an **x-axis option**, "Y-axis crosses at...." Right click
the x-axis and go to Scale.

James Silverton.

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 wrote on Sat, 24 Jun 2006 10:17:02 -0700:

T By the way we don't want anything smaller than 0 show up at
T X axis.

?? It's an **x-axis option**, "Y-axis crosses at...." Right
?? click the x-axis and go to Scale.
??
?? James Silverton.
??

I guess I see what you want and the only thing I can think of at
the moment to have the zero line unobstructed is to have
"y-axis crosses at maximum" checked, which places the y scale on
the right.

James Silverton.

James wrote to Terry on Sat, 24 Jun 2006 13:44:59 -0400:

T By the way we don't want anything smaller than 0 show up at
T X axis.

?? It's an **x-axis option**, "Y-axis crosses at...." Right
?? click the x-axis and go to Scale.
??
?? James Silverton.
??
JS I guess I see what you want and the only thing I can think
JS of at the moment to have the zero line unobstructed is to
JS have "y-axis crosses at maximum" checked, which places the
JS y scale on the right.

Another possibility suggests itself tho' I admit it is a bit
clumsy. After copying the chart with the y-axis crossing
position set at, say -10, open a graphics program and paste. The
unwanted ticks and the "-10" could be erased. As I said, it's
clumsy but I tried it and it's quite easy.

James Silverton.

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.