Filter Pivot Charts in Excel 2010
In Excel 2007, there was a PivotChart Filter Pane, and you had to open that if you wanted to filter the pivot chart. Things have improved in Excel 2010, and the PivotChart Filter Pane is gone.
The field names now appear on the pivot chart, which is great news! Each field button has a drop down arrow, and you can use those drop downs to quickly and easily add or clear the filters.
You can show or hide the individual field buttons, or use the Hide All command on the Ribbon, to control what appears in the pivot chart.
Watch the Pivot Chart Filter Video
To see the steps for creating and filtering a pivot chart in Excel 2010, you can watch this short Excel tutorial video.
Or watch the video on YouTube: Filter Pivot Chart in Excel 2010