Page 371 - Microsoft Office Excel 2003 Programming Inside Out

Part 5: Manipulating Excel Objects
PivotTables and PivotCharts

5 If you press the Options button in the last step of the wizard, the wizard will display
the PivotTable Options dialog box. You can select from a wide range of options, as
shown here.

6 Press the Finish button to create the PivotTable.
When the wizard is finished, you’ll see a PivotTable similar to the one shown in
Figure 16-3.
Chapter 16

Figure 16-3. A PivotTable contains summary information based on the
underlying data supplied.
345