Does anybody know how to change the base of the logarithm used as scale on graphs? I mean, a log base 10 seems to be the default, but I couldn't find a way to change it to anothe base, for example, base 2 (mostly used to express values such as kbytes, mbytes, etc.).
Numbers-OTHER, OS X Mountain Lion (10.8.2)
Hi Leonardo,
I don't know how to change the scale of a graph to Log base 2. Numbers has a LOG function (in addition to LOG10 function).
=LOG(number,2) gives the log to base 2 of number. See the function browser.
Maybe you could transform your data to Log2 and plot as a linear graph?
Regards,
Ian
You're right, Number have 4 log functions: LOG, LOG10, LN and EXP. However, they will change the values, not the scale of the graph. I mean, if I have other values which not fall into an exact log scale the plot will be wrong. But thanks anyway ;-)
Log plots are labeled with the linear values. It's just the spacing that is proportional to the log. But different log bases are proportional to each other, so the base used to compute the spacing is irrelevant. The spacing is the same.
Hi Jeffrey,
I agree with you.
It is just a matter of preentation for the unit I'm wiliing to plot: kbytes, mbytes, ...
Base of a logarithmic scaled graph
