Variant 2 (Advanced Model)

This section follows the same pattern as the last, and explains how to create the 0702_Indicators_02.xlsx file. It focuses in particular on its dynamic elements, namely controls, formulas, and conditional formatting. Note that this section is limited to a discussion of the elements of this file that clearly differ from those of variant 1 of the model as discussed in the previous section (i.e., the basic version in the 0701_Indicators_01.xlsx file). For the following discussion, I assume that you’re already familiar with the information provided there.

On the Companion CD

On the Companion CD

Open the \Samples\0702_Indicators_02.xlsx file on ...

Get Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.