Import Excel chart to diff file (1 Viewer)

[eMel]

Is there a way to import an Excel chart to another Excel file?

Thank You,
eMel

 

[Rx_]

Probably.
Open a Excel instance with the Workbook and worksheet that contains the chart. Assume worksheet name of MyChart
In the same instance open the destination Workbook "book 2"
Go back to the first workbook with the chart. Run this macro

Sub CopyMyChart()
' Rx_ ! Please not Rx_ again
'
'
On Error goto CodeHell   
 Sheets("MyChart").Select
    Sheets("MyChart").Copy Before:=Workbooks("Book2").Sheets(2)
Exit sub
CodeHell:
    msgbox "Please don't touch my keyboard again", , err.description
 
End Sub

 

[eMel]

I found this:
Select first chart - click Copy on the Home tab - click new location - HOLD DOWN THE SHIFT key and click Paste on the Home tab.
When I open the pasted chart, I get a box asking to update or not. Works great.

Thanks Rx!