Paul.
It can be done.
You need to create a new book with the tab you want copied.
Then, in this new book, change the name of the tab. This will change the
references in the charts to this new name.
Move the newly named tab back to the original book. This will also
eliminate the new book.
Results are inconsistent unless you rename a new tab; changing the name of
the tab in the temporary new book seems to be the only way to make the chart
references consistently refer to the new tab.

Create the new book.
Right click on the tab to be copied. Select "Move or Copy".
Select the check box that says "Create a copy".
In the "To book" pulldown select "New Book". Select OK.

Move it back.
Rename the new tab in the new book.
In the new book right click on the new tab with the new name. Select "Move
or Copy".
In the "To book" pulldown select the name of your original file. Select OK.





"Paul R" wrote:

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.