Experts Exchange

Updating an Entire Dashboard with a Radio Button in Excel

Posted on 2015-05-04

Microsoft Excel

3,385 Points

2 Comments

185 Views

2 Endorsements

Last Modified: 2015-05-04

Experience Level: Beginner

22:36

AnnieCushing

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.

Author:AnnieCushing

2 Comments

Expert Comment

by:Vishal Bharakhada2017-11-15

Hi Annie,

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

Regards,
Vishal G. B.

Expert Comment

by:Vishal Bharakhada2017-11-15

Hi,
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.
Regards,
Vishal G. B.

Featured Post

Suggested Videos

Title	Views	Activity
How to use the IF function in Excel	399	3d
Enumerating Prime Numbers in Excel / VBA	432	4d
How to replace or substitute data in Excel	2	2019-04-13
Shuffle - 3 - Table Design	2	2019-06-08

Updating Excel Links in Thousands of Files

Article by: Shaun

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.