|
The beauty
of working with PivotTables and PivotCharts is how easy it is to
update the information in the Table or Chart. Before
You Begin: Go to the Slicer spreadsheet. Select the PivotChart.
The PivotChart Tools should be available. Please remove all Filters
on the Slicers.
1.
Try it: Add More Data Go to the Monthly Sales sheet. Select the
last two Rows: Row 68 and 69. Go to
Home->Copy. Select
Cell A70. Go to
Home->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...
Exam 77-888: Microsoft Excel Expert
2010
3. Presenting Data Visually
3.4. Apply and manipulate PivotCharts
PivotChart Tools ->Analyze
->Data
|
|
| |
