Excel Dashboards and Reports for Dummies, 3rd Edition

Chapter 11

Giving Users an Interactive Interface

In This Chapter

Introducing Form controls

Using a Button control

Using a Check Box control to toggle a chart series

Using an Option Button control to filter your views

Using a combo box to control multiple pivot tables

Using a list box to control multiple charts

Today, business professionals increasingly want to be empowered to switch from one view of data to another with a simple list of choices. For those who build dashboards and reports, this empowerment comes with a whole new set of issues. The overarching question is — how do you handle a user who wants to see multiple views for multiple regions or markets?

Fortunately, Excel offers a handful of tools that enable you to add interactivity into your presentations. With these tools and a bit of creative data modeling, you can accomplish these goals with relative ease. In this chapter, ...