#1
|
|||
|
|||
paste graph between workbook/sheet
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 |
#2
|
||||
|
||||
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:
|
#3
|
|||
|
|||
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 |