Logarithmic Scale for the X-Axis

E

Ed

I am currently using Excel 2007 and need to make a semi-log scale with the
x-axis in log scale. I only see an option to make the y-axis logarithmic
under the format axis menu. Is there anyone that can help?

Thanks in advance.
 
A

Andy Pope

Hi,

You need to use XY-Scatter chart type in order to have X axis using a Log
scale.

Cheers
Andy
 

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

Chart distorts secondary axis when the x-axis is logarithmic 5
Excel - why use a logarithmic scale in a chart? 2
Logarithmic x-axis does not work for seconday axis data series inExcel 2007? 1
Logarithmic charts on different axis 1
Make Y-axis values correspond to x- axis value 1
Scatter chart with categories on x-Axis 2
Formatting 'X' Axis -- 2 fundamental differences 7
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1

Top