I create graphs in a workbook (sheet1) with data in the same worksheet. While I pasted the graph into another workbook, the graphs are still linked to the original workbook/sheet. Is there any "paste special" to let the graphs reconstructed with the data in the target sheet (save data format) so that i do not need to re "Select Data"? The same happens when paste the graphs from one sheet to another within the same workbook.

sand