Analyzing and Visualizing Data with Microsoft Excel — Question 86

You have an Excel workbook that displays two PivotCharts. One chart displays sales by month. The order chart displays sales by year.
You add a slicer for month.
You discover that when you select a month in the slicer, the data in the sales by year PivotChart changes.
You need to prevent the slicer from affecting the sales by year PivotChart.
What should you do?

Answer options

• A. Remove all the fields from the Filters area of the sales by year PivotChart
• B. Modify the Report Connections of the slicer
• C. Modify the Value Field Settings for the values of the sales by year PivotChart
• D. Remove all the fields from the Filters area of the sales by month PivotChart

Correct answer: B

Explanation

The correct answer is B because modifying the Report Connections of the slicer allows you to specify which PivotCharts the slicer will control. Options A and D involve removing fields from Filters, which does not address the issue of the slicer's influence. Option C focuses on Value Field Settings, but that does not relate to slicer connections.