Datasheet

A PivotChart is an Excel chart based on the data in a PivotTable report. It’s more than a

standard Excel chart; however, because it provides many of the same customization capa-

bilities as a report, it’s easy to create a basic PivotChart. All you need to do is make the

PivotTable report active and then click the Chart Wizard button on the PivotTable toolbar.

Go ahead and do this now and you will see the chart shown in Figure 1-15.

Figure 1-15: The PivotChart based on the information in the PivotTable report.

This chart has some elements that don’t appear on standard Excel charts. For example, the

PivotTable Field List is displayed and above the legend is a box labeled Drop Series Fields

Here. These different elements are all PivotChart tools that enable you to customize which

data are shown and how they are displayed. I’ll be getting to these features in Part 6. For

now you can experiment on your own if you wish.

Tip 5: Creating A PivotChart

Part I

03_772402 ch01.qxd 11/30/05 9:41 PM Page 13