graphic2
graphic1

Analyze: Refresh

Say business is good and a lot of new customers were added today. The beauty of working with PivotTables and PivotCharts is how easy it is to update them.

 

Before You Begin: Remove All Filters:
Go to the Slicers spreadsheet.
Select the PivotChart.
Remove the Filters on the Slicers and the Timeline.

 

1. Try it: Add More Data

Go to the Original Data spreadsheet.

Select the last two Rows: Row 68 and 69.

Go to Home->Clipboard->Copy.

Select Cell A70.

Go to Home->Clipboard->Paste.

 

The data in this example has been updated. There are now two more Breakfast Buffets in the records.

 

Did the PivotTable update?
Let's find out.

Keep going...

pic1

Exam 77-428 Microsoft Excel 2013 EXPERT
4. Create Advanced Charts and Tables
4.3   Create and Manage PivotCharts: Analyze PivotChart Data (Refresh)

Insert-> Table-> PivotChart->Use an External Data Source