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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chadillac - 07 Aug 2006 19:03 GMT

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.

Reply to this Message

Jon Peltier - 08 Aug 2006 00:40 GMT

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> Excel should allow me to make a log-log plot with non power of 10 limits
> for
[quoted text clipped - 13 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=162fa6df-bd11-4
7f8-93d2-3e85d53014c4&dg=microsoft.public.excel.charting

Reply to this Message

David Hyde - 08 Aug 2006 07:42 GMT

> 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.

Reply to this Message