Chapter 23: Visualizing with Custom Number Formats and Shapes
23
Constructed shapes can be combined with other shapes to create interesting infographic
elements that can be used in your Excel dashboards. In Figure 23.19, a newly constructed
shape is combined with a standard oval and text box to create nifty infographic widgets.
FIGURE 23.19
Using a newly constructed shape to create custom infographic elements
Creating dynamic labels
Dynamic labeling is less a function in Excel than it is a concept. Dynamic labels are labels
that change to correspond to the data you’re viewing.
Figure 23.20 illustrates one example of this concept. The selected Text Box shape is linked
to cell C3 (note the formula in the Formula bar). As the value in cell C3 changes, the text
box displays the updated value.