Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
stock chart category axis | Charts and Charting in Excel | |||
Combination stock and scatter chart | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel |