Hi,

I want to copy a worksheet containing a graph and the source data in Excel 2007. When I do this, the graph is still linked to the source data on the original worksheet.

In Excel 2003, I was able to copy worksheets and the new worksheet would contain a graph mapped to the source data on the new worksheet (which I could then modify). This provided a quick and easy way of duplicating graphs and changing the data.

Is there a way I can copy the worksheet so that the graph links to the new worksheet data in 2007?

Thanks