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.

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.