Charts - Moving data range over 3 sheets

[Alex Barrow]

Hi All,

I am wondering if this can be done?...

In a workbook, I have 3 sheets ( called sheet1, sheet2, sheet3 )

In column A is the Date, Column B is Item 1, and in Column C is Item 2, the
figures are then below.i.e..

A B C
Date Item1 Item 2
Mon 2 4
Tues 4 5
Wed 3 7

This same setup is on all the 3 sheets, ( but sheet 1 is daily , sheet 2 is
average, sheet 3 is mean values )

What i want to try and do, is chart an Item, along with all 3 factors (
daily , avg, mean ),
BUT they way I want it done, is so i can easily exchange the data range
beween Item 1 and Item 2.

I can do this easily by dragging the data range bars on one item on one
sheet, but is there a way to get that bar to connect & change the columns
over for the other sheets?

Hope this makes sence?

Thanks

 

[Herbert Seidenberg]

Excel 2007 PivotTable, PivotChart
Plot sum, average, median for each item.
Multisheet consolidation compatible.
http://www.mediafire.com/file/mfktthwyyw3/10_24_09.xlsx