Applications
Home Up Past Meetings Notes Links of Interest Site Map FAQs

TOC By Subject ] TOC By Date ] [ Applications ] Topic CrossRef ] Book Reviews ] Key Threads ]

Applications:

Write_Once workbook Journal.   August 2002.  
Techniques to allow entry into a workbook cell only once.   When you move away from the cell, the cell becomes write protected.  
 

This application shows how to make Excel Charts use Bubble size to convey current position in 52 week range,
Bubble Color the P/E ratio
Label the Bubble with the Stock Ticker.
This also has an Excel Chart Click Event.   When you click on a bubble, information for that stock is displayed above the chart.
You can hyperlink to a stock chart from the display.
[August 2004:  This needs updating, but there are some very good techniques to employ here.   
Spotfire is a much better tool to do this kind of work in, but these are useful techniques to do some powerful visualization completely within Excel and IE.

 
   

For questions or comments concerning content on this website: Stephen Rasey
Design of this site by Cheryl D. Wise
Copyright © 2000-2004 by WiserWays. All rights reserved.
Revised: 2005-07-10 01:09 .