By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,720 Members | 2,145 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,720 IT Pros & Developers. It's quick & easy.

Pivot chart filter control

P: n/a
This is a bit of a two-part question.

1. Is there a way to control what filters are placed on a pivot chart
via vba.

I can easily change the underlying query and refresh pivot chart but
it's a big dataset and takes some time to load - my users are
impatient!

2. If this is not possible to code filters on the chart are the any
controls or properties that hold information about what filters are in
place.

e.g. A user opens the pivot chart and then using the field button drop-
downs selects a number of filters. Can I then find out what filters/
selection they have made, since I want to keep this information to use
later.

Cheers

Tom

May 15 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
th***************@gmail.com wrote:
This is a bit of a two-part question.

1. Is there a way to control what filters are placed on a pivot chart
via vba.

I can easily change the underlying query and refresh pivot chart but
it's a big dataset and takes some time to load - my users are
impatient!

2. If this is not possible to code filters on the chart are the any
controls or properties that hold information about what filters are in
place.

e.g. A user opens the pivot chart and then using the field button drop-
downs selects a number of filters. Can I then find out what filters/
selection they have made, since I want to keep this information to use
later.

Cheers

Tom
You might try looking for a book like the Excel Recipe Book. It has a
lot of Pivot Table Information. I think it might be possible to develop
a control to do the filtering that would interact with the Pivot Table.
Another method would be to develop multiple pivot tables with preset
filter controls that you can select with a button control to select a
specific Worksheet in a workbook. I think you can get this in an E-Book.

http://www.contextures.com/

I think this site has some files and some code you might look at also.
May 16 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.