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

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 ...

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