Data Analysis with Microsoft Excel: Updated for Office 2007

284 Fundamentals of Statistics

The PivotChart works the same as the PivotTable. For example, if you

click the Axis Fields button in the PivotChart Filter Pane, you can add or

remove categories from the chart. The pivot chart is also linked to the Pivot-

Table, so any changes you make to layout or formatting of the chart are auto-

matically refl ected in the PivotTable.

Column charts are often used by statisticians when the need is to show the

relative sizes of the groups. For example, it’s quickly apparent from the chart

that the mathematics and science departments have the highest representa-

tion of any category in the data set. What is not clear from the chart is the

size of each group compared to the whole. For example, does the MathSci

group make up more than half of the total respondents? It’s not so easy to

determine that kind of information from the column chart. To deal with that

problem, we can have Excel add the counts to the chart.

To add counts to the column chart:

1 With the PivotChart still selected, click the Data Labels button from

the Labels group on the Layout tab of the PivotChart Tools ribbon.

PivotChart

Figure 7-8
PivotChart of
department
affiliation

PivotChart Tools ribbon