2007 Microsoft® Office System 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 either 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 15-25). Excel creates a PivotTable at the ...