If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Dynamic Range with unused formula messing up x axis on dynamic graph | [email protected] | Charts and Charting | 2 | February 2nd, 2006 08:02 PM |
"X" Axis with different scale | maperalia | Charts and Charting | 0 | January 18th, 2006 07:28 PM |
2 axis bar graph | Steve | General Discussion | 3 | March 29th, 2005 11:06 PM |
Value Axis Change Problem in Chart | dp_fulcher | General Discussion | 1 | October 19th, 2004 03:01 AM |
Two Y axis in Graph | Debra Dalgleish | Charts and Charting | 0 | March 20th, 2004 09:39 PM |