ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   With 2 pivotcharts, can I keep their page selections syncronized? (https://www.excelbanter.com/excel-discussion-misc-queries/87149-2-pivotcharts-can-i-keep-their-page-selections-syncronized.html)

srisa

With 2 pivotcharts, can I keep their page selections syncronized?
 
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?

Debra Dalgleish

With 2 pivotcharts, can I keep their page selections syncronized?
 
There's a sample file here that changes the page field in related pivot
tables when the master table is changed:

http://www.contextures.com/excelfiles.html

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

It may help you get started


srisa wrote:
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?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 04:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com