Refresh the PivotChart

2. First, Review the PivotChart

Go to the Slicer spreadsheet.

Did the PivotTable or PivotChart update? Maybe,..maybe not. What if it didn't?

 

OK, Try This: Refresh the Data.

Click on the PivotChart to select it.

Go to PivotChart Tools ->Analyze ->Data.

Click on Refresh.

 

What Do You See? The data for the Breakfast Buffet has updated. The sales subtotal has been updated to include the two, new sales.

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.4. Apply and manipulate PivotCharts

PivotChart Tools ->Analyze ->Data-> Refresh