Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting x axis values on bottom in a logarithmic scale chart
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting x axis values on bottom in a logarithmic scale chart
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 _______ "Steven" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Getting x axis values on bottom in a logarithmic scale chart
That did it. Thanks!
"Jon Peltier" wrote: 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 _______ "Steven" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In the x axis, logarithmic scale | Charts and Charting in Excel | |||
logarithmic scale on x-axis | Charts and Charting in Excel | |||
Chart Axis Scale Auto Values | Charts and Charting in Excel | |||
how can I make a chart with the x-axis in logarithmic scale | Charts and Charting in Excel | |||
How I can do on x-axis, logarithmic scale? | Excel Discussion (Misc queries) |