Making your dashboard interactive

While the elements described are very useful in creating dashboards, the key objective is to engage your reader. Your dashboards should have options for them to interact with the data, explore different scenarios, and come away with insights that matter to them.

Excel offers several features and techniques to make dashboards interactive. Here are some ways you can make your Excel dashboards interactive.

Slicers

Slicers are interactive controls that allow users to filter and slice the data displayed in a dashboard. By connecting slicers to tables or PivotTables, users can easily select specific data subsets or filter by various criteria, such as dates, categories, or regions. Slicers provide a user-friendly way to explore data and customize the dashboard’s view.

Let’s proceed to add a Region slicer to our dashboard. The objective is to make the user see the key indicators on the dashboard filtered by the selected region in...