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
|
|||
|
|||
logarithmic scale in excel?
how do i plot a graph with the x axis in a semi log format using excel 2007?
i no how to do it in the previous version of excel but cant find out how to do it in this version...thanks for any help |
#2
|
|||
|
|||
logarithmic scale in excel?
Right click on the axis to be treated (the numbers will then have a box
around them) Select Format Axis from the popup menu to open the format dialog On the Axis Options tab (look to the left to see the tab names), about half-way down, locate Logarithmic Scale and check the box Note that we can now use logs to various bases not just 10; I like to use base 2 in many circumstances best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sukh" wrote in message ... how do i plot a graph with the x axis in a semi log format using excel 2007? i no how to do it in the previous version of excel but cant find out how to do it in this version...thanks for any help |
#3
|
|||
|
|||
logarithmic scale in excel?
Sukh -
To have a logarithmic scale on the x axis, the x axis must be a numerical axis, not a category axis. So, in any version of Excel, you must use an XY (Scatter) chart type. Then, Format Axis | Axis Options | Logarithmic scale .... - Mike http://www.MikeMiddleton.com "Sukh" wrote in message ... how do i plot a graph with the x axis in a semi log format using excel 2007? i no how to do it in the previous version of excel but cant find out how to do it in this version...thanks for any help |
Thread Tools | |
Display Modes | |
|
|