O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required