Asked by Sarah Elizabeth on Jun 04, 2024
Verified
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.
Data Source
A data source is any repository or location from which data is collected, including databases, files, sensors, or any informational context.
PivotChart Layout
A format or structure applied to PivotCharts in spreadsheet applications, determining how data is summarized and displayed visually.
Workbook Links
References between different Microsoft Excel workbooks that allow data in one workbook to automatically update based on changes in another workbook.
- Familiarize yourself with the process of personalizing data visualization through the manipulation of PivotTable and PivotChart elements.
- Refresh and update PivotCharts and PivotTables to reflect changes in the underlying data source.
Verified Answer
NA
Naiya AbramsJun 09, 2024
Final Answer :
A
Explanation :
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.
Learning Objectives
- Familiarize yourself with the process of personalizing data visualization through the manipulation of PivotTable and PivotChart elements.
- Refresh and update PivotCharts and PivotTables to reflect changes in the underlying data source.