O'Reilly logo

Excel Pivot Tables Recipe Book: A Problem-Solution Approach by Debra Dalgleish

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

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

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