Pivot Chart Filtering Query (Excel 2010)

Hi,

In the attached Excel Spreadsheet, there is a simple 4 columns of data which i want to filter down by in the chart.

When I apply the first filter (i.e. Filter column 'A' and just select '9'), I desire to only see the data in the other columns corresponding to those rows with '9' in, i.e. only '4' and '5' from Column 'B', is this possible with a PivotChart?

Regards,
Kevin
PivotFilter.xlsx
kev-griggsAsked:
Who is Participating?
 
Rory ArchibaldCommented:
If you mean will the filter in B respect the filters applied in A, then the answer is no, unfortunately - unlike autofilters, pivot filter dropdowns don't do that.

Edit: just noticed you are using 2010 so you can use Slicers - see attached version of your workbook.
PivotFilter.xlsx
0
 
kev-griggsAuthor Commented:
Hi rorya,

So there is no way to achieve what I want?

Kev
0
 
Rory ArchibaldCommented:
Yes - using Slicers (which grey out the inapplicable items) as in the revised workbook I added.
0
 
kev-griggsAuthor Commented:
Slicer worked perfectly, thanks for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.