286 Fundamentals of Statistics
From the pie chart we can easily see a graphical comparison of the size
of each department group relative to the entire collection of departments
represented in the survey. The graph retained these count labels when we
converted to the pie chart, but we can change that option as well. We can
display the percentage of each slice, and we can add a label to the slice
identifying which category it represents.To change the pie chart’s display options:1 With the PivotChart still selected, click the Data Labels button again
and then click More Data Label Options from the menu.
Excel opens the Format Data Labels dialog box.
2 Click the Percentage check box and deselect the Value check box.
3 Click the Category Name check box.
4 Click the Close button.
The chart changes as shown in Figure 7-11, displaying the percent-
ages and labels for each pie slice.Figure 7-10
Pie chart
with counts