Figure

The PivotChart Tools.

erly Sates By Category PivotChart.xlsx - Microsoft Excel PivotChart TooIs

Formulas Data Review View Developer

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

FIGURE 12.17

Opening the palette of chart styles.

14. A palette of 54 styles opens as shown in Figure 12.18.

15. The formatted PivotChart is shown in Figure 12.19.

Part II

FIGURE 12.18

Selecting a chart style from the palette.

FIGURE 12.18

Selecting a chart style from the palette.

FIGURE 12.19

A PivotChart with contrasting color bars and a light background.

FIGURE 12.19

A PivotChart with contrasting color bars and a light background.

16. For a computer presentation, a dark background may be preferable; Figure 12.20 shows the PivotChart with a dark background style selected.

0 0

Post a comment