| Microsoft Office 2000/Visual Basic Programmer's Guide | |
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.