Thread: shift Y axis
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Terry
 
Posts: n/a
Default shift Y axis

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.