Creating rollover hyperlink dashboard in Excel is not a daily routine for most Excel users. In this tutorial we will show you how to create a nice rollover dashboard using hyperlinks.
We have one data table, four regions and four periods (quarters). How to visualize regional sales performance in one dynamic chart? We will help you to sharpen your data visualization techniques. Come with us it will be fun!
We will create dynamic dashboard templates in Excel. Rollover solutions can be useful to present instant info to the customer or user. Sometimes it can be very difficult to choose our ideal Excel function that we need. No longer stress, all we need is to build the custom function yourself.
The hyperlink cells (marked using blue arrows) have an IF formula which uses hyperlink and the rollover action built in macro. Hovering over the arrow, changes the value of ’Actual_RNG’ and the chart.
We have to open VBA window then view Module 1 press ALT + F11 keys together to see this code.
This little function will help us! What is „Actual_RNG” ? The picture below shows the actual range (Region2 – We marked in using green font colour)!
To edit or view named ranges in file click on Formula tab then click on Name Manager.
You can check the dashboard in motion.
Download the sample workbook to try this very cool rollover hyperlink dashboard function!