Working with PivotTable and PivotChart Reports

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

PivotTable and PivotChart reports are powerful tools for presenting and analyzing data. A user can manipulate a single PivotTable report to display the same data in dozens of different ways. Until you get the hang of them, however, PivotTable reports can be confusing. The following sections introduce the basics of PivotTable reports, then describe how to build and control them by using VBA.