<

Updating an Entire Dashboard with a Radio Button in Excel

Posted on
3,408 Points
208 Views
2 Endorsements
Last Modified:
Published
Experience Level: Beginner
22:35
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

Comment

by:Vishal Bharakhada
Hi Annie,

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

Regards,
Vishal G. B.
0

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
The Indian number format for currency has groups of two and three digits. The native Format function of VBA cannot handle this if Windows is set for a Western localisation. Thus, a custom method must be applied. Here it will be shown how to use dyna…
Depending on the things you do with Microsoft Office, you can sometimes inadvertently lose your recent document lists in apps such as Microsoft Word and Excel. This article shows you how to back up and restore those lists when necessary. Enjoy...

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month