Making 1 Pivot chart from 3 different worksheets.

S

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
 
S

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
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top