Data Analysis with Microsoft Excel: Updated for Office 2007

Chapter 7 Tables 285

2 Click Center from the list of Data Label options.

Excel updates the chart, which now shows the counts for each col-

umn in the PivotChart. See Figure 7-9.

Figure 7-9

Column chart
with counts

From this display we can see that 128 respondents come from the MathSci

group, which corresponds to the information we saw earlier in the PivotTable.

Displaying Categorical Data in a Pie Chart

Another way of comparing the size of individual groups to the whole is

the pie chart. A pie chart displays a circle (like a pie), in which each pie

slice represents a different category. Let’s see how the pie chart displays the

department data. Rather than re-creating the chart from scratch, we’ll simply

change the chart type of the current graph.

To display a pie chart:

1 With the PivotChart still selected, click the Change Chart Type but-

ton located on the Type group of the Design tab on the PivotChart

Tools ribbon.

2 Select the fi rst Pie Chart subtype listed in the Change Chart Type

dialog box and click the OK button.

Excel displays the pie chart in Figure 7-10.