Excel 2007 PivotTables Recipes: A Problem-Solution Approach

CHAPTER 10Pivot Charts

After you create a pivot table, you can create a pivot chart, based on one of the pivot tables in your workbook. A pivot chart can't be created on its own; it must be based on a pivot table. Pivot charts are similar to normal Excel charts, but they have some differences and limitations, as described in this chapter. Except where noted, the problems in this chapter are based on the Sales10.xlsx sample file.

10.1. Planning and Creating a Pivot Chart

Problem

The sales manager is preparing for a budget meeting in the East region, and she asked you to create a pivot chart, to show the sales for each food category at each store.

You created a pivot table on the Region Pivot worksheet, with Store and Category in the Row Labels ...