Excel Pivot Tables Recipe Book: A Problem-Solution Approach

CHAPTER 12Pivot Charts

When you create a PivotTable report, you can create a PivotChart report at the same time, or you can create a PivotChart report at any time later, based on one of the pivot tables in your workbook. A PivotChart report can't be created on its own; it must be based on a PivotTable report. PivotChart reports are similar to normal Excel charts, but have some differences and limitations, as described in this chapter.

12.1. Stepping Through the Chart Wizard to Create a Pivot Chart

Problem

If you select a cell in the pivot table and click the Chart Wizard button on the Standard toolbar, a default pivot chart on a chart sheet is created. You'd like to step through the Chart Wizard so you can set the options as you create the pivot ...