how can I make a chart with the x-axis in logarithmic scale

D

Doris

how can I make a chart with the x-axis in logarithmic scale. the built in
function makes the y-axis log
 
A

Andy Pope

Hi,

You need to use the xy scatter chart type if you want an x-axis log scale.

Cheers
Andy
 
A

Andy Pope

Double click the x axis. This should display the format dialog.
On the Scale tab is the option for Log scale (very similar to y axis
method).

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

Logarithmic Scale for the X-Axis 1
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
Finding asymptote equation and how to draw them in excel 0

Top