How to copy/export Excel Chart then paste/insert into Word file

I have a chart in spreadsheet.The chart itself reference formulas in different cells and worksheets all within the same workbook.

I want to copy/export the chart in spreadsheet then insert/paste into Word file. I know how to do this using Office automation. But new to Open XML. Is it possible to do this?
Any help would be appreciated! I am using SDK 2.0 and VB.NET

Thanks

Ottawa,

I created something similar to what you are trying to accomplish. However, all of my data was contained on individual spreadsheets in their own workbooks. If you can set the workbooks up like that, you can try looking into using content controls to map them to the appropriate workbook.

Check out Eric White's blog http://blogs.msdn.com/ericwhite/default.aspx I found a lot of his information extremely helpful.

Let me know how it goes.

Yes.. You can do this using Open XML.

Here is a blog which explains the same scenario

http://blogs.msdn.com/brian_jones/archive/2009/03/13/importing-charts-from-spreadsheets-to-wordprocessing-documents.aspx

HTH,
Ankush