Updating an Entire Dashboard with a Radio Button in Excel

Posted on
3,385 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

OWASP: Threats Fundamentals

Learn the top ten threats that are present in modern web-application development and how to protect your business from them.

Excel allows various different methods to link Excel files to each other. This includes relative paths, mapped drives (or the local drive) and UNC paths. UNC paths are the least robust of the three.
Using a Vlookup with one of Excel's random number functions to create randomized columns of data from pre-defined lists.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month