Special Edition Using® Microsoft® Office Excel 2003

Chapter 24. Using PivotTables and PivotCharts

In this chapter

• Understanding PivotTables

• Using the PivotTable and PivotChart Wizard

• Creating PivotCharts

• Modifying PivotTables and PivotCharts

• Working with Dates in PivotTables

• Creating a PivotTable from Multiple Ranges

• Saving and Editing PivotTables in HTML Format

Understanding PivotTables

A PivotTable uses two-dimensional data to create a three-dimensional table—in essence, a summary table based on multiple conditions that have intersecting points. PivotTables are a great way to summarize large amounts of information in a small amount of space, with just a few short steps. They’re interactive in that, after the PivotTable is created, you can drag a field to another location, thus pivoting the structure of ...