Simple question- how to make X axis on bottom of chart

  • Thread starter Thread starter Boon8888
  • Start date Start date
B

Boon8888

Hi, pretty self explanatory, and probably a quick fix. Basically my
data in my chart varies between -5 and -15 on the y axis. As a result
the X axis labels appear at the top of the chart, and not the
traditional way at the bottom. I would like them to be at the bottom,
and i'm sure it must be a quick fix. Any one know how to do it?

Thanks,

Joel
 
Right click y-axis; format
open Scale tab and set Crosses X axis at -15 (or -20 if you prefer)
best wishes
 
An alternative leaves the axis line and ticks at zero but moves the labels
out of the way. Right click the X axis, select Format, and on the Patterns
tab, choose the Low option for Tick Labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top