Special Edition Using Microsoft® Office XP

Creating and Editing PivotCharts

A PivotChart is a chart based on data in a PivotTable. Like its row-and-column-based counterpart, you can rearrange a PivotChart by dragging field labels on a chart sheet. When you change the layout of a PivotChart, Excel automatically rearranges the corresponding data in your PivotTable, and vice versa.

PivotCharts were introduced in Excel 2000, and they're a welcome addition. In general, anytime you can use a PivotChart instead of a conventional chart, you should jump at the opportunity, because they're so much easier to create and edit.

PivotCharts follow almost exactly the same rules as charts you create from a conventional worksheet. The default chart type for a PivotChart is a stacked column chart, but you ...