Export graph datasheet from Powerpoint to Excel

C

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
[email protected]
 
S

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.
Click to expand...

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
 
C

Cong Nguyen

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

Regards,
Cong
 
B

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
 
Top