Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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/comm...excel.charting |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 _______ "Chadillac" wrote in message ... 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/comm...excel.charting |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() Chadillac wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
xy scatter chart-How can you make the axis equal for a 1H:1V plot | Charts and Charting in Excel | |||
plot data on two axis at the same time, metric and english units | Charts and Charting in Excel | |||
dot plot - single x axis location with multiple y axis dots | Charts and Charting in Excel | |||
X axis scale on an XY scatter plot | Charts and Charting in Excel | |||
how to add a second x axis with same Y axis value in one plot | Charts and Charting in Excel |