***
Dynamic Funnel Chart
Figure 1 |
Hyperlink:
Read also the information and explanation on the website of Chandoo.org
http://chandoo.org/wp/2011/07/20/interactive-dashboard-using-hyperlinks/
Figure 2
Place a hyperlinks in the cells of the hotspot – see above.
|
Figure 3 Formula: Define the hotspot with the name: “ valSelOption” |
Figure 4 |
Figure 5 — Chart with hotspot |
See: Figure 5/6
Figure 5 — The “hotspot” |
Above the hotspots and the linked cells. Special formed to make an easy crossover.
- All Excel LOOKUPs Explained - May 26, 2020
- How to: Power Query File From Folder - April 21, 2020
- Oz’s Excel Tip: Keep a Workbook for Random Data in Excel - January 23, 2020