O'Reilly logo

Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond by Reinhold Scheck

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7. Elements of Dynamization

From here on, we’re going to slowly but surely pick up steam. I’ve already mentioned dynamic, multivariable Excel solutions a couple of times, and you’ve already encountered some (admittedly rather rudimentary) examples of these. By the end of this chapter, you’ll be more familiar with the four components that really allow you to make the most of Excel’s flexibility and the benefits it offers in terms of visualization. The necessary structural basis is provided by the rS1.Method. In this chapter, we’ll combine the use of:

  • Standardized range names

  • Controls

  • Extracting formulas

  • Conditional formatting

In order to follow the instructions here without difficulty and to implement these with ease in the exercises I suggest ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required