Thanks for sharing the link. It still doesn't solve my problem though, the options listed are pasting with link, without or embedding, neither of which work for my situation.

My solution would be closest to the embed option but only the chart data is embedded, not the rest of the excel