Getting x axis values on bottom in a logarithmic scale chart

[Steven]

I had a normal line chart - zero on the bottom, 100% on top of the y scale.
I changed it to logarithmic and now the x axis values are at the top of the
chart, not the bottom.

If I go to Format Axis: Scale, I can select Categories in Reverse Order,
which flips the entire chart. THis puts the x axis values where I want them,
on the bottom of the screen, but puts the zero on top and 100% on bottom,
which i do NOT want.

If I go to Format Axis: alignment, I can offset the x axis values, but not
down at the bottom of the chart.

Please help.

 

[Jon Peltier]

Double click the X axis or the labels themselves. On the Patterns tab, in
the bottom right, select Low for Axis Tick Labels.

- Jon

 

[Steven]

That did it. Thanks!

Double click the X axis or the labels themselves. On the Patterns tab, in
the bottom right, select Low for Axis Tick Labels.

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