software

I have several pivotcharts based on the same source data. I use them to show
several variables of the data at the same time. Is there a way to make sure
that when I change the page selection for 1, all the other have the same
change?

There's a sample file here that changes the page field in related pivot
tables when the master table is changed:

www.contextures.com/excelfiles.html

Under 'Pivot Tables' look for 'Change Page Field'

It may help you get startedsrisa wrote:
gt; I have several pivotcharts based on the same source data. I use them to show
gt; several variables of the data at the same time. Is there a way to make sure
gt; that when I change the page selection for 1, all the other have the same
gt; change?--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html