Question

You would like to filter your Pivot Chart from five product rows to three rows. Where do you do this, and are there any changes made to your Pivot Table?

Answer 1

To filter a Pivot Chart from five to three product rows, you need to modify the corresponding Pivot Table by deselecting the unwanted products. This change will reflect both in your Pivot Table and Pivot Chart.

Step-by-step explanation:

To filter your Pivot Chart from five product rows to three rows, you would do this in the Pivot Table that your Pivot Chart is based upon.

In Excel, this is done by going to the Pivot Table and unchecking the product rows that you don't want to display in the Pivot Chart. Here are the steps:

• Select the Pivot Table.
• Go to the field list on the right side of your screen.
• Under the 'Rows' or 'Columns' section, uncheck the boxes next to the products that you don't want in your Chart.

When you do this, changes are indeed made to your Pivot Table. Your Pivot Table will now only display the remaining three products. Similarly, your Pivot Chart will update to only display data from these three products.

Learn more about Pivot Chart Filter