Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making 1 Pivot chart from 3 different 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making 1 Pivot chart from 3 different worksheets.
Excel 2007 PivotTable
Consolidate Tables With Chart and Macro http://www.mediafire.com/file/jonz2mhtdzd/09_02_09.xlsm |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making 1 Pivot chart from 3 different worksheets.
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 "Herbert Seidenberg" wrote: Excel 2007 PivotTable Consolidate Tables With Chart and Macro http://www.mediafire.com/file/jonz2mhtdzd/09_02_09.xlsm |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making 1 Pivot chart from 3 different worksheets.
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" wrote: Excel 2007 PivotTable Consolidate Tables With Chart and Macro http://www.mediafire.com/file/jonz2mhtdzd/09_02_09.xlsm |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making 1 Pivot chart from 3 different worksheets.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making changes automatically on multiple worksheets | Excel Discussion (Misc queries) | |||
ADDING A TRENDLINE WHEN MAKING A CHART FROM A PIVOT TABLE | Charts and Charting in Excel | |||
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 | |||
merging two worksheets into one pivot chart | Charts and Charting in Excel |