Reader, Bert van Zandbergen, from Beekbergen, The Netherlands (Holland) sent me his own cool creation based on the Rollover technique I created. I asked if I could post his work to this blog to which he graciously agreed.
Below is his write up. Some of the Excel functions below are in Dutch (which I think is really cool). If you’re confused, download the file first – your version of Excel will show the functions in your language of choice. And, of course, if this technique is new to you, read the the tutorial on how to do Excel rollovers.
***
Dynamic Funnel Chart
by
Bert van Zandbergen
The Netherlands
Based on this file:
 |
| Figure 1 |
Start with the 4 columns. The dummy had to be 100 or more for space to unfilled dummy bars. Delete the lines. Now you can change the value from “100” to “1”. Further information is visible in 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 |
Go to VBA and insert a module. For more information about the instruction – see on this website, the Chandoo website and the module above.
 |
| Figure 5 — Chart with hotspot |
The hotspot is based on 10 columns combined with 42 rows. – see figure 5/6. The hotspots are linked by hyperlinks with corresponding cells in columns AI:AR. For a special effect and an easy crossover the values are placed in a diagonal figure
See: Figure 5/6
 |
| Figure 5 — The “hotspot” |
Above the hotspots and the linked cells. Special formed to make an easy crossover.
***
A big thank you to Bert – hopefully there will be more contributions in the future!
Do you have something interesting to share? Send me an email or drop me a line on LinkedIn.
Jordan Goldmeier is an accomplished data professional with a wealth of experience across various industries. He currently serves as a consultant at Anarchy Data, where he assists businesses in maximizing the capabilities of Excel for financial planning and analysis. Jordan is also an instructor at Full Stack Modeller and a former Adjunct Instructor in Analytics at Wake Forest University. His extensive career has seen him hold positions as the Chief Operations Officer at Excel.TV, Data Science Manager at DataKind, Data Scientist at Dealer Tire and EY, Analytics & Data Vis Developer at The Perduco Group, and Operations Research Analyst at Booz Allen Hamilton. Jordan's background in data analytics and his passion for Excel make him a valuable resource for businesses seeking to improve their data-driven decision-making processes.
Latest posts by Jordan Goldmeier (see all)
- 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
