Chart references when copying worksheets -- HELP!
 

I want to copy a worksheet which includes several charts. When I do this,
the charts refer to data on the original worksheet, as opposed to the new
worksheet.

How can I make a worksheet copy that has all its charts refer to cells on
the new sheet? Manually changing all the references would be very time
consuming, particularly if I want to make several copies of the sheet.