?
Solved

Pivot Chart Filtering Query (Excel 2010)

Posted on 2013-06-04
4
Medium Priority
?
373 Views
Last Modified: 2013-06-04
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
0
Comment
Question by:kev-griggs
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 2000 total points
ID: 39218359
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
 

Author Comment

by:kev-griggs
ID: 39218367
Hi rorya,

So there is no way to achieve what I want?

Kev
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 39218459
Yes - using Slicers (which grey out the inapplicable items) as in the revised workbook I added.
0
 

Author Closing Comment

by:kev-griggs
ID: 39218535
Slicer worked perfectly, thanks for your help.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question