Export graph datasheet from Powerpoint to Excel

[Cong Nguyen]

Hi All,
Please show me how to export all datasheet in Powerpoint to Excel.
I have a presentation with many graphs created directly in Powerpoint and
now want to learn how to export and save just the raw data in Excel format.
Thank you for your help.

Sincerely,
Cong Nguyen
(e-mail address removed)

 

[Steve Rindsberg]

Please show me how to export all datasheet in Powerpoint to Excel.

I have a presentation with many graphs created directly in Powerpoint and
now want to learn how to export and save just the raw data in Excel
format.

I don't think there's any simple way to automate this.

Manually, you can doubleclick a graph, copy its data, paste it into a
worksheet, then repeat until you're done with all of the graphs

 

[Cong Nguyen]

Steve,
Thank you.
This is a painful way. I have more than 250 graphs/datasheet.

Regards,
Cong

 

[Brian Reilly, MVP]

Steve,

you scared me with your earlier answer since I am about to write
some fairly elaborate code to do this. Yes, it can be done
programmatically.

Brian Reilly, MVP