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


G

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
 
Ad

Advertisements

J

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
 
Ad

Advertisements

D

David Hyde

Chadillac said:
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.
 

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

Top