Part III: Creating Charts and Other Visualizations
Layering shapes to save space
Here’s an idea to get the most out of your dashboard real estate. You can layer pie charts
with column charts to create a unique set of views (see Figure 23.17).
FIGURE 23.17
Combine shapes with a chart to save dashboard real estate.
Each pie chart represents the percent of total revenue and a column chart showing some
level of detail for the region. Simply layer your pie chart on top of a circle shape and a col-
umn chart.
Constructing your own infographic widgets with shapes
Excel offers a way to alter shapes by editing their anchor points. This opens up the possi-
bility of creating your own infographic widgets. Right-click a shape and select Edit Points.
This places little points all around the shape (see Figure 23.18). You can then drag the
points to reconfigure the shape.
FIGURE 23.18
Use the Edit Points feature to construct your own shape.
