Updating a PivotTable or PivotChart
You can quickly update a PivotTable report using the PivotTable Field List or the Analyze tab under PivotTable or PivotChart Tools, which appears whenever a PivotTable or PivotChart is active. When you do want to add or remove data to and from a PivotTable or PivotChart, Excel makes it easy by allowing you to select or clear field check boxes. After selecting fields, you can change the display for rows and columns, filter data, and display a summary. In addition, you can use multiple tables in a PivotChart using the Excel Data Model (New!).
Add or Remove a Field in a PivotTable or PivotChart
Click any field ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
