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, ...
Get Excel Dashboards and Reports For Dummies, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.