How to filter a pivot chart

Let’s take a look.

Lets create a pivot chart that shows product sales by Region.

Since we have a pivot table already, well create a pivot chart first, and then start customizing.

Go to the Options tab of the PivotTable Tools ribbon and hit the PivotChart button.

For chart styles, well use a simple column chart.

At this point, our chart is plotting the full set of source data.

Lets filter the pivot chart to show only certain products: Banana Chocolate and Orange Chocolate.

One way to do this is to add Product as a Report Filter.

you could filter the data in a pivot chart directly using field buttons.

With the field buttons visible, we can manually filter to show only Orange and Banana Chocolate.

Now the chart displays only the data for those 2 products.

If we check the pivot table, we see it is filtered in exactly the same way.

Using the pivot table, you’re able to filter the chart in any way you like.

For example, lets exclude the East region from this chart.

To clear filters, you might use the Clear Filters command that appears in each Field Button menu.

All filters will be removed from both the pivot table and pivot chart.