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
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
文章標籤
全站熱搜
