stock chart non-linear y-axis
 

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


--
Alseikhan
------------------------------------------------------------------------
Alseikhan's Profile: http://www.excelforum.com/member.php...o&userid=32364
View this thread: http://www.excelforum.com/showthread...hreadid=527234

stock chart non-linear y-axis
 

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)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Alseikhan" wrote
in message ...

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


--
Alseikhan
------------------------------------------------------------------------
Alseikhan's Profile:
http://www.excelforum.com/member.php...o&userid=32364
View this thread: http://www.excelforum.com/showthread...hreadid=527234

stock chart non-linear y-axis
 

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

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
_______

"Bernard Liengme" wrote in message
...
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)
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Alseikhan" wrote
in message ...

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


--
Alseikhan
------------------------------------------------------------------------
Alseikhan's Profile:
http://www.excelforum.com/member.php...o&userid=32364
View this thread:
http://www.excelforum.com/showthread...hreadid=527234