Chapter 7 Tables 287The pie chart is an effective tool for displaying categorical data, though it
tends to be used more often in business reports than in statistical analyses.EXCEL TIPS
To view the source data for any particular cell in a PivotTable,
double-click the cell. Excel will open a new worksheet contain-
ing the observations from the original data source that make up
that cell.
You can specify data sources other than the current workbook
for your PivotTable data, such as databases and external fi les.
If the values in the data source change, the PivotTable updates
automatically to refl ect those changes.
You can create your own customized functions for the PivotTable.
To do so, select any cell in the table and click the Formulas button
located in the Tools group of the Options tab on the PivotTable
Tools ribbon, and then click Calculated Field.•
•
•
•
Figure 7-11
Pie chart with
percentages
and labels