plot log-log with non power of 10 limits for x-axis

[Guest]

Excel should allow me to make a log-log plot with non power of 10 limits for
the X axis.

In engineering environments, especially when working in the frequency
domain, it is usefull to be able to plot someting like 20-2000 Hz in a
log-log plot. Having to choose a power of 10 is a waste of chart area.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...85d53014c4&dg=microsoft.public.excel.charting

 

[Jon Peltier]

Excel does not support log scales that do not terminate at powers of ten,
but you can fake it by transforming your data and building a fake axis.
Tushar Mehta shows how on his web site. Browse to http://tushar-mehta.com
and look for the Flexible Log Axis.

- Jon

 

[David Hyde]

Excel should allow me to make a log-log plot with non power of 10 limits for
the X axis.

In engineering environments, especially when working in the frequency
domain, it is usefull to be able to plot someting like 20-2000 Hz in a
log-log plot. Having to choose a power of 10 is a waste of chart area.

DPlot (http://www.dplot.com) will do what you want with a log scale. It
includes an Add-In for Excel that facilitates moving data from Excel to
a DPlot graph.