Logarithmic type charts

  • Thread starter Thread starter Guest
  • Start date Start date
Frank

Thanks for the link. Interesting site, but it doesn't quite answer my question. I'm looking for a way to configure both the x and y axes to a logarithmic scale. It seems that Excel only allows the y-axis to be configured to a log scale. I'm hoping that there's a trick

Regards
Trevo
 
Create a XY Scatter chart. Then, double-click each axis in turn, and in
the resulting dialog box, from the Scale tab, check the 'log scale'
checkbox.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2004
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 
Hi Trevor
try using the X/Y Scatter diagram type. Format both axis (double click
on the axis to open the dialog) with a log scale
 
Tushar

Thanks for your response. I tried that before, but the dialog box for the x-axis does not have an option for a log-scale. My version of Excel is 2002 SP-1. Maybe it's too old

Thanks
Trevo
 
Frank, Tushar

Got it! User error! My problem was that I wasn't selecting the xy scatter type. Thanks for your help

Regards
Trevo
 
You must log in or register to reply here.

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
Horizontal axis to the bottom 1
Logarithmic trendlines 1
Error bars plot black triangles 6
Major and minor gridlines on logarithmic axis excel 2007 7
negative/zero values on logarithmic plot warning 4
0 on a logarithmic axis 4
logarithmic scales 2

Back
Top