• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Analyzing Worksheet Data > Updating a PivotTable and PivotChart

Updating a PivotTable and PivotChart

You can quickly update a PivotTable report using the PivotTable toolbar, which appears whenever a PivotTable is active. This saves you from having to recreate a PivotTable every time you add new data to a list. When you do want to add new data, Excel makes it easy by allowing you to drag data fields to and from a PivotTable or PivotChart.

Update a PivotTable Report

Make any necessary change(s) in the worksheet where your list range resides.

If necessary, select a different worksheet, and then click any cell in the PivotTable Report.

Click the Refresh Data button on the PivotTable toolbar, or click the PivotTable drop-down arrow on the PivotTable toolbar, and then click Refresh Data.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint