View Single Post
  #2   Report Post  
Tushar Mehta
 
Posts: n/a
Default

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