In previous versions of Excel, when you copied a worksheet within a workbook
any charts in that worksheet would update to the new worksheet. In the Excel
2007 I have, the charts remain linked to the original sheet. I don't want
that. How do I make charts stay linked to the worksheet they are in and not
where they originated? For instance, I want to make a chart in sheet1 then I
want to copy sheet1 and change the name to sheet2. I then want to change data
in sheet2 and have the chart in sheet2 update to the data in sheet2 without
having to go to the source data and change everything manually. As it is now,
I have to manually change the source data to get it to link to the new sheet.
This is terribly painful when you have multiple charts and multiple data
sets. Thanks!