838
Chapter 30 Using PivotTables and PivotCharts
How PivotTable and PivotChart Reports Work
PivotTables and PivotCharts are powerful tools for automatically summarizing and analyz-
ing data without ever having to add a formula or function. As the name implies, you start
with a list in table format, snap the rows and columns into position on a grid, and end up
with a sorted, grouped, summarized, totaled, and subtotaled report. PivotTable reports are
best for cross-tabulating lists—the more categories, the better. You can reduce a list of thou-
sands of items to a single line, showing totals by category or quarter. Or you can create
complex, multilevel ...