• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple Pivot Charts/Tables, 1 Report Header

W

WarpathMechanic

New Member
So here is my dilemma:


I have to create both a print and a digital version of a yearly review. The digital one was easy enough (pivot tables, pivot charts, some data manipulation, all thanks to this site), however converting it easily to print has got me stumped.


What I am trying to accomplish is have multiple pivot tables/charts underneath one report filter so that when I tell excel to show the report filter pages, it takes ALL the tables and charts with it.


I have thought about data validation and using tables to do it but that is a TON of manual work and we are talking 1000000+ rows of data when this is all compiled.


Any help is greatly appreciated. I can upload what I have so far but I just need to find out how to do it.
 
Sorry for the late reply. My company has blocked every site except google docs and I am trying to get it fitted to GDocs standards. The report will be coming!
 
Finally got a chance to get it on google docs. here is the link:


https://docs.google.com/spreadsheet/ccc?key=0AviubZlnLY-4dDJ5ZFRmR1RlSjFuRmswWGxtU1dtZnc
 
A thought. Since it can and will be printed. Can I use INDEX, MATCH, and COUNTIF on something like Sales Office to get the unique values out of the list, reference that to get a table of data using SUMIFS then reference that to get the charts then copy and paste for each sales office then set up for printing.


That's a run on sentence if I ever saw one but it was an idea...
 
You must log in or register to reply here.
Back
Top