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.
Opinions expressed in the article are those of the guest author and not necessarily Search Engine Land.