Updating an Entire Dashboard with a Radio Button in Excel

Posted on
3,339 Points
2 Endorsements
Last Modified:
Experience Level: Beginner
This Micro Tutorial will demonstrate how to create an interactive dashboard in Microsoft Excel. The entire dashboard is controlled by a set of radio buttons. Every chart in the dashboard updates show the segment of data as you select a new option.
  • 2

Expert Comment

by:Vishal Bharakhada
Hi Annie,

This is awesome. Thank so much for sharing this video.

Vishal G. B.

Expert Comment

by:Vishal Bharakhada
I have created this in excel 2016. All is working perfectly except color change. Whenever I apply to color for particular month it is getting applied to all month data.
Please suggest.
Vishal G. B.

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Join & Write a Comment

Debits & Credits have been the foundation of financial record keeping since 1494 - over 500 years. Excel is a brilliant tool for leveraging this ancient power - not least with Pivot Tables, sorting and filtering.  This article seeks by illustration …
Are you encountering the error message “The workbook cannot be opened or repaired by Microsoft Excel because it is corrupted” when trying to open the MS Excel workbook, and you are not able to open the workbook? If your answer to this question is a …

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month