LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
Alseikhan
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
stock chart category axis Bill Charts and Charting in Excel 2 March 13th 06 01:28 PM
Combination stock and scatter chart ArtZ Charts and Charting in Excel 1 January 8th 06 07:59 PM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
Stacked Bar Chart with Secondary Axis Benjamin B Charts and Charting in Excel 7 May 15th 05 04:00 AM
Second X axis at top of chart? Phil Hageman Charts and Charting in Excel 1 December 29th 04 01:48 PM


All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"