Excel should be able to do log to base 2 charts

P

pgb123

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/charts/chartdl.asp?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/com...f29bf50c16&dg=microsoft.public.excel.charting
 
T

Tushar Mehta

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
 
J

Jon Peltier

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/ChartIndex.html#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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top