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 ...
Get Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond 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.
