Pivot chart filter control

[thomas.wordsworth]

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

[Last Boy Scout]

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.