Using stock market data from your favorite online online financial site WiserWays stockbubble chart will create:
- Relative Strength on the X Axis
- "Combined Rank" (of several metrics) on the Y Axis
- P/E Ratio in Color (see Legend)
- Ratio of Current Price to 52 week High as the size of the bubble. the Smaller the bubble, the further from the 52 week high..
- Data is for one industrial category
- Selecting one of the points on the graph brings up more information about the stock (text line above the chart).
- With one click, you can hyperlink to a historical price chart on the selected stock.
This chart is built entirely within Excel using VBA subroutines and functions. WiserWays can show you how to make your in-house Excel workbooks do these kind of charts.
Download the stockbubble.zip file and try it for yourself.