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

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.