In order to change a PivotChart in Excel, you must first __________.
A) change the source data
B) change the source data and refresh the PivotChart
C) right click the PivotChart to edit
D) do nothing. PivotCharts are dynamic so once the source data is changed it automatically updates

Question

Quizplus · Accepted Answer

To change a PivotChart in Excel, you must change the source data of the PivotTable on which the PivotChart is based and then refresh the PivotChart to reflect those changes. This ensures that the PivotChart displays the most current data.

In Order to Change a PivotChart in Excel, You Must