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

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
 
B

Bernard Liengme

Right click y-axis; format
open Scale tab and set Crosses X axis at -15 (or -20 if you prefer)
best wishes
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Horizontal axis to the bottom 1
Positioning x axis at bottom of chart with negative values 5
Is it possible to put explanatory text at bottom of pie chart? 1
Make Y-axis values correspond to x- axis value 1
Chart distorts secondary axis when the x-axis is logarithmic 5
X-axis labeling 1
Line Chart - Problems with labeling X-Axis 3
Trying to color every other X axis interval... 6

Top