Base 2 Log Plot in Excel - How?
Base 2 Log Plot in Excel - How?
(OP)
I'd like to plot some data on a semilog plot but in excel the default for log plots is base 10 (i.e. 1,10,100 etc). Is it possible to setup a plot such that the x-axis is base 2, and starts at 125 (i.e. 125,250,500 etc)?
(Reason is - I'm trying to plot some noise data on a dB vs. Octave graph, with Frequencies between 125 and 8K Hz)
Thanks.
(Reason is - I'm trying to plot some noise data on a dB vs. Octave graph, with Frequencies between 125 and 8K Hz)
Thanks.





RE: Base 2 Log Plot in Excel - How?
RE: Base 2 Log Plot in Excel - How?
The workaround basically adds another data series which takes the place of the X-axis (or Y-axis, the principle is the same). This works a little bit better than a superimposed text box.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Base 2 Log Plot in Excel - How?
RE: Base 2 Log Plot in Excel - How?
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Base 2 Log Plot in Excel - How?
RE: Base 2 Log Plot in Excel - How?
Sorry to bring this up from the dead but (un)fortunately I was recently upgraded to Office 07 and found out that Excel now has a built-in option to change the "base" of the log plot. It works quite well.