LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Multiple Pivot Tables in same worksheet

I am trying to set up multiple pivot tables on the same data -- one worksheet
to routinely genrate updted reports or charts as data is added. Some charts
show trend data by year, which I get by grouping the date entries to "year."
Another report reflects seasonality, which I get by grouping by month.
However, whenever I change the grouping on one table or chart, it changes on
all others.
Any ideas?

So far, it seem like all other items remain particular to the table cjosen,
e.g. variables, value field settings, etc. but if there is anything else that
would behave like grouping, I nee to know how to keep that fixed as well.

Thanks,
Bob

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
build a pivot table from multiple other pivot tables. Gordo Excel Discussion (Misc queries) 1 December 11th 06 08:19 PM
Two pivot tables on the same worksheet? I need help... Erik Excel Worksheet Functions 0 April 27th 06 02:37 PM
how do I consolidate multiple pivot tables into one pivot table? pkahm Excel Discussion (Misc queries) 0 April 20th 06 09:48 PM
Multiple Pivot Tables? Kimbe Charts and Charting in Excel 0 April 17th 06 05:08 PM
Multiple Pivot tables from One selection dapo Excel Discussion (Misc queries) 2 December 29th 05 03:02 PM


All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"