Microsoft Office Tutorials and References
In Depth Information
Updating a PivotTable or PivotChart
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 in the PivotTable or PivotChart report.
Select or clear the check boxes next to the fields you want to include or ex-
clude from the PivotTable and PivotChart.
Search JabSto ::




Custom Search