Correctly Copying Worksheets When "Chart Data Range Too Complex"?

Question

MS-Excel 2008 on OSX Mavericks. I don't think the problem is very version- or platform-specific.

1. Make a simple chart on a worksheet.
2. Make a copy of the worksheet.
3. Note the new chart in the new worksheet refers to the new worksheet, as it should.
4. Fiddle with the data so as to get the "Chart Data Range Too Complex" message in the "Select Data" dialog box. Just setting the data series name to a cell somewhere away from the data is enough to do it for me.
5. Make another copy of the worksheet.
6. Note that the newest chart in the newest worksheet doesn't refer to the newest worksheet.
7. Wail, gnash teeth, etc.

Imagine that making the "chart data range too complex" go away is not an option.

Any other workarounds?