How can PivotCharts be used in conjunction with PivotTables to enhance data visualization?
Instruction: Discuss how PivotCharts complement PivotTables and provide an example of their combined use for data analysis.
Context: This question assesses the candidate's ability to use Excel's data visualization tools, specifically PivotCharts, in conjunction with PivotTables for a comprehensive analysis.
Updated
Official answer available
Read the opening below, then unlock the full answer and practical guidance.
A PivotTable aggregates a defined source; its associated PivotChart visualizes that aggregate and follows the applicable field/filter state. It is interactive, but not inherently a live connection to fresh source records.
For sales, use Month in Rows, Product category in Columns and Sum of Revenue in Values...