Creating a PivotTable

You can create a PivotTable from either an Excel range or an external data source. If you’re working from an Excel range, your data should meet the criteria for a well-constructed list. That is, it should have column labels at the top (the headings will become field names in the PivotTable), each column should contain a particular kind of data item, and you should not have any blank rows within the range. If the range includes summary formulas (totals, subtotals, or averages, for example), you should omit them from the PivotTable; the PivotTable will perform its own summary calculations.

The source range on your Excel worksheet can be a table or an ordinary list. Starting from a table has the advantage of allowing for expansion. ...

Get 2007 Microsoft® Office System Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.