Getting x axis values on bottom in a logarithmic scale chart

G

Guest

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.
 
J

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
 
G

Guest

That did it. Thanks!

Jon Peltier said:
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
_______
Click to expand...
 

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
How do I move the x-axis to the top of the graph? 1
Creating a line chart with two X-axes!! 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Scale of Graph Axis 2
Positioning x axis at bottom of chart with negative values 5
Chart X-Axis in reverse order! 1
Excel chart - great variation in values 1

Top