Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine/Merge 7 charts into one | Charts and Charting in Excel | |||
Merge charts into Word document | Charts and Charting in Excel | |||
how do i merge 4 different charts with the same x and y axis | Excel Discussion (Misc queries) | |||
Merge data to form w/charts HELP PLEASE | Excel Discussion (Misc queries) | |||
[Help] How to merge two charts? | Charts and Charting in Excel |