stock chart non-linear y-axis

[Alseikhan]

A chart displays columns representing #shares traded for a group of 20
stocks along x-axis. Because the displayed values span a wide range
(some columns are 1000x larger than others) the small volume stocks are
hardly visible. What is needed is a way to make Y-axis non-linera;
however, a log scale is useless because of the enourmous compression
that takes place at the higher end of the y-axis.
Is there a way of displyaing non-linear values at a scale less than
allowed by log values? Web-based stock charts do this regularly, for
example see chart displayed on Yahoo finance of Apple Computers (symbol
AAPL)

http://finance.yahoo.com/q/bc?s=AAPL&quicken=2

Any help here? Thank you.

Alseikhan

 

[Bernard Liengme]

That chart has a Log scale!
However, it displays y values rather than Log(y) on the axis

Should be possible with Bovey's XY Chartlabeler (www.appspro.com)

 

[Jon Peltier]

Rob's Labeler, plus transformed data allowing an arbitrary scale. Look here:

http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

or at the Arbitrary Log Axis example on Tushar Mehta's site

http://tushar-mehta.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______