Dashboard Series: Update An Entire Excel Dashboard With One Radio Button
In this month’s installment of my Excel dashboard series, I’m going to show you a trick that will give you the ability to control an entire dashboard with one menu — in this example, a radio button menu.
For my example, I’ve put “months” in the menu at the top of the dashboard, but you could put anything in there to segment your charts and tables:
- marketing channels
- departments in a company
- sales staff
- traffic source
For more, including a sample file and a video, check out the full column on Marketing Land.
Some opinions expressed in this article may be those of a guest author and not necessarily Search Engine Land. Staff authors are listed here.
(Some images used under license from Shutterstock.com.)
Analytics news and expert advice every Thursday.