Excel 2010 Bible

Chapter 35: Analyzing Data with Pivot Tables

737

A pivot chart includes field buttons that let you filter the chart’s data. To remove the field buttons,

right-click a button and choose the Hide command from the shortcut menu.

When you select a pivot chart, the Ribbon displays a new contextual tab: PivotChart Tools. The

commands are virtually identical to those for a standard Excel chart, so you can manipulate the

pivot chart any way you like.

FIGURE 35.25

This pivot table summarizes sales by region and by month.

FIGURE 35.26

The pivot chart uses the data displayed in the pivot table.