paste graph between workbook/sheet

sandsoppa · #1 02-25-2011, 12:02 PM

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

Colin Legg · #2 02-25-2011, 02:16 PM

I don't think there's a brilliant way to do this. Here is Jon Peltier's (a chart wizard) response to the same question:

Quote:

The easiest and least tedious way is to copy the original worksheet that
contains the chart. The copied chart thus links to the copied worksheet.
Now copy the data from the table on the second worksheet, and
paste-special-values or -formulas into the table on the copied worksheet.

sandsoppa · #3 02-25-2011, 02:29 PM

thanks for the information

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
macro to transfer data from one workbook to another workbook	virsojour	Excel Programming	5	02-01-2011 08:58 PM
How do I merge data from one sheet in a workbook out into multiple sheets	nolesca	Excel	4	06-07-2010 08:13 AM
Select a range in one one workbook while working in other workbook	Slow&Steady	Excel	1	02-21-2010 03:34 AM
copy cell from sheet 2 to sheet 3 macro	slipperyjim	Excel Programming	1	02-18-2010 01:31 AM
Word - Calculate and paste values from Excel sheet	Augf87	Word	1	07-06-2009 10:26 AM