Quote:
Originally Posted by jlrdouglas
I know this is an old thread, but I just found a solution to this and I've been wrestling with this problem for months now so I wanted to share it:
1.Create a New Workbook
2. Copy the worksheet to the new workbook
(right click: Move or Copy, select create a copy and put it in the new workbook)
3. Change the name of the worksheet to its new name in the new workbook
4. Move the newly named worksheet back to the old workbook
The chart references will point to the data on the newly named worksheet.
|
You need to enable an option for this to work if the charts are embedded
on the worksheets where the data is, rather than on a chart sheet of
their own.
Go to Excel options Advanced Cut, Copy and Paste section.
Enable "Cut, copy, and sort inserted objects with their parent cells"