Question

changing the selection under the filter button for month in the picture below will:

○ change the values in the pivot chart only.

○ change the values in the pivot table

○ change both the pivot table and the pivot chart

Explanation:

In Excel, pivot tables and their linked pivot charts are dynamically connected. Filtering a field (like 'Month') in the pivot table interface will update the data displayed in the pivot table, and the pivot chart, which is directly sourced from the pivot table, will automatically reflect the same filtered data.

Answer:

Change both the pivot table and the pivot chart