Pivot Tables/Charts and common filter


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.

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