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

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

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
_______

"Bernard Liengme" <[email protected]> wrote in message
news:%[email protected]...
> 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" <[email protected]> wrote
> in message news:[email protected]...
>>
>> 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
>>
>
>