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