Creating a PivotTable

You can create PivotTables from four kinds of data:

  • An Excel list

  • An external data source

  • Multiple "consolidation" ranges (separate Excel lists that the PivotTable And Pivot-Chart Report command will consolidate as it builds your PivotTable)

  • Another PivotTable

In the example that follows, we'll create a PivotTable from the Excel list shown in Figure 30-1. For information about creating a PivotTable from an external data source, see "Creating a PivotTable from External Data". For information about creating a PivotTable from multiple consolidation ranges, see "Using a PivotTable to Consolidate Ranges". For information about basing one PivotTable on another, see "Building a PivotTable from an Existing PivotTable".

Starting the PivotTable ...

Get Microsoft® Office Excel 2003 Inside Out now with O’Reilly online learning.

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