Hi Andrew. After reading your comment, I checked again, and it seems my referencing issue is just happening on one workbook, for some reason. If I open a new book, and create a few graphs, then any embedded graphs in the copy reference the new sheet copy, just as happens for you.
But on my original worksheet, not so. Granted, there are about a zillion graphs in the worksheet concerned, so this might be causing excel to do something different for this particular worksheet.
I found a few posts on the net with other people having a similar problem. Perhaps it only rears its head when there's heaps of graphs involved, or some other factor.
By the way, in your reply, hid you mean to say that te references remain unchanged only if you copy the cells or the charts to another workbook (rather than worksheet)? If not, this doesn't seem to sqare with your comment that copying a sheet within the workbook also results in the charts' references to change to the copied sheet. Or (just as likely) Ive misinterpreted your statement.
Thanks for your comment.