|
merge pivot charts?
I have 3 seperate charts created from 3 pivot tables. each table has a filter
office#. user has to go to each table to select office# to get the charts update. Is there any way to merge 3 tables together, that way user can select only one time and get the different info for each table? pivot_table_1 office# answers pivot_table_2 office# answers pivot_table_3 office# answers |
merge pivot charts?
You can use programming to change the selections in the related pivot
tables. There's a sample file he http://www.contextures.com/excelfiles.html Under PivotTables, look for 'PT0021 - Change All Page Fields' JJ wrote: I have 3 seperate charts created from 3 pivot tables. each table has a filter office#. user has to go to each table to select office# to get the charts update. Is there any way to merge 3 tables together, that way user can select only one time and get the different info for each table? pivot_table_1 office# answers pivot_table_2 office# answers pivot_table_3 office# answers -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
| All times are GMT +1. The time now is 07:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com