If you edit the data source of a PivotTable report, what must you do so the corresponding PivotChart reflects the changes?
A) Refresh the PivotChart.
B) Change the PivotChart layout.
C) Change the data source of the PivotChart.
D) Update the links in the workbook.

Question

Quizplus · Accepted Answer

When you edit the data source of a PivotTable, you need to refresh the PivotChart so that it reflects the changes made. This can be done by right-clicking on the PivotChart and selecting "Refresh". Option B is incorrect, as changing the PivotChart layout would not necessarily reflect the changes made to the data source. Option C is also incorrect, as changing the data source of the PivotChart would create a new chart altogether. Option D is irrelevant in this context, as updating links in the workbook does not relate to the task at hand.

If You Edit the Data Source of a PivotTable Report