 | |
| How to Create Interactive Dashboard Tabs in Excel - Ultimate Excel Dashboard Ep. 6 |
How to Create Interactive Dashboard Tabs - Ultimate Excel Dashboard Ep. 6
In this Excel Tutorial you will learn how to create custom interactive dashboard tabs that allow us to display additional content (e.g. charts) without requiring any additional space in the dashboard. You will not only learn how to create the required shapes and the necessary VBA code, but also learn about two different ways to this.
The previous four episodes we covered how to build the basic interactive Excel dashboard and had a detailed look into advanced background, gradient tile and pivot slicer designs. We also solved the challenge of automatically updating pivot tables and pivot charts when the source data changes and created the first custom interactive feature, the info button.
The following Episode will go deeper into the creation and integration of a truly advanced features, a collapsable settings menu area with state-of-the-art radio buttons for dashboard color theme selection and modern toggle buttons to control the visibility of specific dashboard elements.
Download Free:
Post a Comment