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?
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
