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.