Pivot Tables/Charts and common filter

K

Kathy L.

I have a set of data which is used to generate multiple pivots charts. Each
set of pivot charts also runs from different data worksheets. However, for
each chart the report filters need to remain the same.

I was wondering if you can link the report filters together so that when you
make a change to one filter all the filters change to the same selection. Is
this possible? Thank you.
 
H

Herbert Seidenberg

Is an Excel 2007 VBA solution acceptable?
If yes, provide sample data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Single Filter to change all Pivot Tables in a Workbook 8
pivot tables 4
Pivot Charts 3
Copying Sheet with Pivot charts 3
Pivot Data and Filter on separate sheets 1
pivot table filter 6
EXCEL FILTERS AND CHARTS 2
Filter pivot table zero values 1

Top