O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required