Quick Excel Question

Soldato
Joined
16 Apr 2007
Posts
23,436
Location
UK
Hey all,

Just a quick Excel question for you :)

I need to move the (x) axis down to the bottom (So the numbers on the axis are on the line of -30 on the (y) axis.

I hope this makes sense - I don't need the line to move, I just want the details on the (x) axis on the bottom line.

i1ino0.png


Any help would be appreciated :)

Thanks,

Marky
 
I'm on Excel 2007 here, but if I right click on the x-axis itself and select format axis, under the axis options, there's a "label distance from axis" option. Increase this until the labels are in the desired position. Iirc this option is present in 2003...but I'm not certain.

Even better, just noticed this:

asdasdxy.jpg


Selected 'low' and the labels remain at the bottom all the time, no matter the size of the graph.
 
Last edited:
Back
Top Bottom