Are you making the copy using Copy & Paste?
Try this instead: Hold down the CTRL key and drag the tab of the worksheet
you want to copy. Drag it left of right and when you release the mouse
button you will see a new sheet with a name like Sheet1 (2). This will be an
exact replica of the original and the chart will refer to cell on its on
sheet.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Paul R" <Paul wrote in message
...
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.