Logarithmic type charts

[Guest]

Is it possible to plot a log-log type chart in Excel? If so, how?

 

[Frank Kabel]

Hi Trevor
have a look at
http://www.tushar-mehta.com/excel/newsgroups/flexible_log_scale/index.h
tml

maybe this is what you're looking for?

 

[Guest]

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

 

[Tushar Mehta]

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

 

[Frank Kabel]

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

 

[Guest]

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

 

[Guest]

Frank, Tushar

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

Regards
Trevo