Making 1 Pivot chart from 3 different worksheets.

[spudsnruf]

Hi, I have 2 workshsheets of data with a list of delivery dates of about 10
different products over the last 3 years, (i cant combine these to just 1
worksheet for other separate reasons) and a 3rd worksheet with a column of
the same products and dates that some of these products became faulty and
were sent back to me .

On a 4th worksheet, I am trying to do a graph that looks at the 3
worksheets and plots pivot table of dates and amount of each product
deliveries & returned to me. So as i select ,say, product A from that pivot
list, it produces a graph for these 3 variables (dates and amount delivered
and returned). I can do a pivot table for each workseheet at a time, but I
cant work out how do 1 pivot table that does it all. Is it possible, or is
there a better way at approaching the problem?

Thank you very much for any help

 

[Herbert Seidenberg]

Excel 2007 PivotTable
Consolidate Tables
With Chart and Macro
http://www.mediafire.com/file/jonz2mhtdzd/09_02_09.xlsm

 

[spudsnruf]

Wow. Thanks for taking the time to post this. Its very close to what I need,
my 2 questions are...if I wanted to be able to filter your example by
'Product' and then make that appear in the chart page..how would I do that?
Also is there any steps on how I would anyway get to produce that pivot chart
in your example. Thanks very much

 

[spudsnruf]

Correction from me. ignore the 1st part of my last reply to your guidance
Herbert, as I just saw the Product filter on the pivot table. However, is
there any where I cam see how you did this pivot, as its exactly the sort of
thing I wanted, but dont know how to get there. Thanks very much.

 

[Herbert Seidenberg]

Buy the "Pivot Tables" book.
Nothing better.
http://www.contextures.com/