How to move the x axis to the bottom

[Matt]

I have an xy plot where the x axis runs from 1 to 100 and
the y axis from 1e-7 to 1e-13 (as a log scale).

Excel insists on putting the x axis at the top ie crossing
at 1e-7. I need the axis at the bottom, crossing the y
axis at 1e-13.

Any ideas please?

Matt

 

[Jerry W. Lewis]

Double click on the y-axis, select the Scale tab, and change the value
in the "Value (X) axis Crosse at:" to 1e-13.

Jerry

 

[Jon Peltier]

If the minimum on the Y axis may change, select the most ridiculously
small number you can think of. 1e-50, 1e-300, whatever. Excel won't go
below the actual axis minimum.

There is a checkbox for Axis Crosses at Maximum, but not for Minimum. I
think when Microsoft designed Excel, they didn't foresee half of the
way's we'd all abuse it.

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