Home |
Search |
Today's Posts |
#1
|
|||
|
|||
simoultaneous pivot tables
How do you change the page field on multiple pivot tables? I am creating
multiple pivot charts from the pivot tables and the only field that al of the tables have in common is the page field. The row, data, and column fields are different. All of the pivot charts are based off of the same source data. If I have to do itin VB, can someone give me an example? I don't know how to do pivot tables in VB. |
#2
|
|||
|
|||
You can do this with programming. There's a sample file he
http://www.contextures.com/excelfiles.html Under Pivot Tables, look for 'Change Page Field' guntherdh wrote: How do you change the page field on multiple pivot tables? I am creating multiple pivot charts from the pivot tables and the only field that al of the tables have in common is the page field. The row, data, and column fields are different. All of the pivot charts are based off of the same source data. If I have to do itin VB, can someone give me an example? I don't know how to do pivot tables in VB. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
overlapping pivot tables | Excel Discussion (Misc queries) | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |