Embed an Excel Chart into PowerPoint - VBA

[Junoon]

Thanks Admin.
I see you are creating a temp workbook to embed the chart. However, it does not give the same effect as PasteSpecial - "Use Destination Theme & Embed Workbook (H)". I am using Excel 2010.
,
When i right-click the chartobject, i get 3 options:
1] Open
2] Edit
3] Convert.

But i do not get 'Edit Data' option, which i would normally get when i PasteSpecial into a new Presentation using option "Use Destination Theme & Embed Workbook (H)".

When i select 'Edit' option, i get an embedded workbook in the chart itself and not as a standalone excel window.

Can you try copying the chart and pasting it in a new powerpoint presentation and see the difference? See attached files for example.
In ppt deck, slide 1 is from your code, slide 2 is manually pastespecial by me using option "Use Destination Theme & Embed Workbook (H)". You will notice the difference. When you right-click the 2nd slide chart, it opens a new workbook in a new window with title showing "Chart in Microsoft Excel". I am unable to replicate this option.

Hope this is clear.