<

Updating an Entire Dashboard with a Radio Button in Excel

Posted on
3,396 Points
196 Views
2 Endorsements
Last Modified:
Experience Level: Beginner
22:36
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
  • 2
2 Comments

Expert Comment

by:Vishal Bharakhada
Hi Annie,

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

Regards,
Vishal G. B.
0

Expert Comment

by:Vishal Bharakhada
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.
0
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
Do you want to increase the data integrity of your Excel worksheets?  Do you input something repeatedly?  Would it be handy to pick the item from a predetermined (by you) list?  READ ON!

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month