Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Making a Pivot chart from 3 differnt sets of data / worksheets.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making 1 Pivot chart from 3 different worksheets. | Excel Discussion (Misc queries) | |||
2 data sets in pivot tables | Excel Worksheet Functions | |||
Cell referencing between differnt worksheets | Excel Discussion (Misc queries) | |||
Making a chart using data from different worksheets in a workbook. | Charts and Charting in Excel | |||
Making a chart using data from different worksheets in a workbook. | Charts and Charting in Excel |