February 2013
Beginner to intermediate
576 pages
21h 30m
English
Content preview from Excel® 2013 On Demand
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...