Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i change the x-axis of a graph to a log scale?
i've got some data that i want to display on a semi log graph, but i want to
change the x-axis to a log scale, not the y-axis. How do i do this? anne |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i change the x-axis of a graph to a log scale?
Anne:
Double click any value on your x axis, this will bring up Axis format form. Select scale tab, check Logarithmic checkbox. Make sure that your minimum value is 1, 10, 100, and your major & minor units must be multiples of 10. ...Kelly "anne" wrote in message ... i've got some data that i want to display on a semi log graph, but i want to change the x-axis to a log scale, not the y-axis. How do i do this? anne |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i change the x-axis of a graph to a log scale?
That's great, thanks
anne "Kelly O'Day" wrote: Anne: Double click any value on your x axis, this will bring up Axis format form. Select scale tab, check Logarithmic checkbox. Make sure that your minimum value is 1, 10, 100, and your major & minor units must be multiples of 10. ...Kelly "anne" wrote in message ... i've got some data that i want to display on a semi log graph, but i want to change the x-axis to a log scale, not the y-axis. How do i do this? anne |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i change the x-axis of a graph to a log scale?
Make sure you create (or change to) a XY Scatter chart. Now, double-click
the x-axis and in the resulting dialog box, select the Scale tab. The last step should be self-evident. {grin} -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... i've got some data that i want to display on a semi log graph, but i want to change the x-axis to a log scale, not the y-axis. How do i do this? anne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the axis in excel to the american style | Charts and Charting in Excel | |||
Changing the scale major unit in a graph | Excel Discussion (Misc queries) | |||
X-Y Graph with Months, Not Date on Axis | Excel Discussion (Misc queries) | |||
How to specify values for X axis in a Graph | Charts and Charting in Excel | |||
How do I change the scale of the catagory axis? | Charts and Charting in Excel |