When the PivotChart (or one of its components) is selected, you should see special
PivotChart commands in the Design and Layout groups of the Ribbon; if you don’t see
them, click the PivotChart to give it the focus.- To give the chart a title (generally a good idea), I selected Layout 1 in the Chart
Layouts group on the Design tab of the Ribbon (in PivotChart Tools mode), as shown in
Figure 12.16.
FIGURE 12.16
The PivotChart Tools.- This selection adds a Chart Title control to the chart; right-click it and select Edit Text to
edit the chart name as desired; I made it “Quarterly Sales by Category.” - The final step is to select a chart style. The default style (contrasting color bars) is gener-
ally fine, but there are lots more choices available. To select a different chart style, drop
down the More button at the lower-right corner of the Chart Styles group, as shown in
Figure 12.17.
FIGURE 12.17
Opening the palette of chart styles.- A palette of 54 styles opens as shown in Figure 12.18.
- The formatted PivotChart is shown in Figure 12.19.
NOTENOTE
Going Beyond the Basics 12