How to access the data in a Powerpoint created chart into an Excel?

[rajtilak]

I have a couple of Powerpoint decks, the first few slides of which contains charts created in PPT. Which means, they don't have the underlying data available readily in an Excel. At present what I do is, I go in these presentations individually, open the data for the charts in Excel, copy them, and paste them in a separate Excel and go on to the next slide to do the same. Is there a way to achieve this using VBA? Everywhere I looked they are showing the opposite, which is creating charts using VBA from data in an Excel.

 

[thisoldman]

I found this, with VBA by Andy Pope:

http://www.excelforum.com/excel-general/955420-convert-embedded-powerpoint-chart-to-excel.html

With Google, one can search for a literal string by enclosing that string in quotation marks:

copy "powerpoint chart to excel"

I've not found a way to search for literal strings using Bing.

Allowing Google to omit "similar results", there were only nine result links. Going from Powerpoint to Excel is obviously not often done. I hope this helps.

 

[rajtilak]

You Sir are a savior!

 

[thisoldman]

I'm glad my post helped. Thank you for posting back.