Thread: Excel should be able to do log to base 2 charts

Log base 2 charting is standard throughout the stock marketing charts world
and Excel really ought to be able to do it by now.

Indeed, your own MSN stock site does it fine, so why on earth is it not in
Excel by now?

e.g. http://moneycentral.msn.com/investor...sp?Symbol=MSFT
go to the bottom and you'll see you can do log base 2

Users will LOVE it !!!


Please add it ASAP




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

If you want, you can implement your own log n chart by recognizing that

Log(X,n) = Log(X)/Log(n)

Effectively, a Log-base-2 chart will look *identical* to a log-base-10
chart except that all values will be scaled by Log(2). And, if the y-
values are in the original scale, about the only thing that will (may?)
change are the grid lines!

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <31ECDD96-25D8-43FD-96F6-AEF29BF50C16@microsoft.com>, pgb123
@discussions.microsoft.com says...
> Log base 2 charting is standard throughout the stock marketing charts world
> and Excel really ought to be able to do it by now.
>
> Indeed, your own MSN stock site does it fine, so why on earth is it not in
> Excel by now?
>
> e.g. http://moneycentral.msn.com/investor...sp?Symbol=MSFT
> go to the bottom and you'll see you can do log base 2
>
> Users will LOVE it !!!
>
>
> Please add it ASAP
>
>
>
>
> ----------------
> 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
>

Excel doesn't do a lot of things, but it lets you work around the
deficiencies. How did you do a log2 chart in the old days, with only
paper, pencil, and your fingers to count on? You determined your own
scale, transformed the data yourself, and plotted it accordingly.

Here is a set of examples on how to make your own custom axis scales:

http://peltiertech.com/Excel/Charts/...tml#AxisScales

Follow the examples, using your own transformation, log-base-2, in place
of the more complicated ones I may have used.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


pgb123 wrote:

> Log base 2 charting is standard throughout the stock marketing charts world
> and Excel really ought to be able to do it by now.
>
> Indeed, your own MSN stock site does it fine, so why on earth is it not in
> Excel by now?
>
> e.g. http://moneycentral.msn.com/investor...sp?Symbol=MSFT
> go to the bottom and you'll see you can do log base 2
>
> Users will LOVE it !!!
>
>
> Please add it ASAP
>
>
>
>
> ----------------
> 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