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 […]

Chat with SearchBot

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.

OfficelogoOrange_WebFor 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.


About the author

Annie Cushing
Contributor
I'm a Senior SEO at SEER Interactive, an Internet marketing agency in Philadelphia. My areas of focus are SEO, analytics, and data collection and analysis. My claim to fame is I make data sexy — and teach other marketers how to do the same.

Get the must-read newsletter for search marketers.