Excel® 2013 On Demand

Charting a PivotTable

Data summarized in a PivotTable is an ideal candidate for a chart, since the table itself represents an overwhelming amount of data. A chart of a PivotTable is called a PivotChart. Once you select data within the PivotTable or table (New!), you can chart it like any other worksheet data using similar tabs and buttons—PivotChart and Recommended PivotChart (New!)—under PivotChart Tools. You can also use the AutoFilter menu to filter data directly in the PivotChart report, just like in a table. The additional Analyze tab provides options to collapse or expand fields, insert a slicer, refresh or clear data, and show or hide the Field List and different Field Buttons on a PivotChart. To change chart elements, you can use the ...