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:
- countries
- marketing channels
- departments in a company
- sales staff
- traffic source
- affiliates
- etc.
For more, including a sample file and a video, check out the full column on Marketing Land.
Contributing authors are invited to create content for Search Engine Land and are chosen for their expertise and contribution to the search community. Our contributors work under the oversight of the editorial staff and contributions are checked for quality and relevance to our readers. The opinions they express are their own.