logarithmic scale in excel?

S

Sukh

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
 
B

Bernard Liengme

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
 
M

Mike Middleton

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
 

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

Logarithmic Scale for the X-Axis 1
Excel - why use a logarithmic scale in a chart? 2
Finding asymptote equation and how to draw them in excel 0
Chart distorts secondary axis when the x-axis is logarithmic 5
Logarithmic x-axis does not work for seconday axis data series inExcel 2007? 1
Shortcuts in OneDrive 0
Export BPMN Visio Chart to Excel 0
Plotting Graph with dynamic table 3

Top