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.


Opinions expressed in this article are those of the guest author and not necessarily Search Engine Land. Staff authors are listed here.


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.