Excel Dashboards & Reports For Dummies, 4th Edition

Chapter 11

Giving Users an Interactive Interface

IN THIS CHAPTER

Introducing macros

Recording macros

Adding macros to your dashboards and reports

Introducing Form controls

Using Form controls to dynamically filter your report views

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 reporting. With these tools and a bit of creative data modeling, you can accomplish these goals with relative ease. In this chapter, you discover how to incorporate various controls, such as buttons, check boxes, and scroll bars, into your dashboards and reports. Also, I present you with several solutions that you ...