Microsoft® Excel® 2010 Inside Out

Creating PivotCharts

PivotCharts, like PivotTables, summarize tabular information and allow for easy transposition of fields and axes. They’re a great way to study or present elements of your data set.

You can create a PivotChart directly from your source data by selecting a cell in the original data range, clicking the Insert tab, clicking the arrow beneath PivotTable in the Tables group, and then clicking PivotChart. After you specify or confirm your data source and indicate where you want the new PivotChart to reside (in a location on the existing worksheet or on a new worksheet), Excel presents both a PivotTable layout and a blank chart canvas, along with a PivotChart Filter Pane. (See Figure 23-27.) Excel creates a PivotTable at the same time ...