Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / September 2007

Tip: Looking for answers? Try searching our database.

Export graph datasheet from Powerpoint to Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cong Nguyen - 07 Sep 2007 19:12 GMT
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
cong.nguyen@gulfstream.com
Steve Rindsberg - 08 Sep 2007 04:43 GMT
> 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 - 10 Sep 2007 14:18 GMT
Steve,
Thank you.
This is a painful way. I have more than 250 graphs/datasheet.

Regards,
Cong
Signature

Cong Nguyen
cong.nguyen@gulfstream.com

> Hi All,
> Please show me how to export all datasheet in Powerpoint to Excel.
[quoted text clipped - 5 lines]
> Cong Nguyen
> cong.nguyen@gulfstream.com
Steve Rindsberg - 10 Sep 2007 16:03 GMT
> Steve,
> Thank you.
> This is a painful way. I have more than 250 graphs/datasheet.

I understand.  You could probably do it automatically using VBA if you're a
fairly proficient coder.  This wouldn't be a beginning project though.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ:  www.pptfaq.com
PPTools:  www.pptools.com
================================================
Brian Reilly, MVP - 12 Sep 2007 03:36 GMT
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

>> Steve,
>> Thank you.
[quoted text clipped - 8 lines]
>PPTools:  www.pptools.com
>================================================
Steve Rindsberg - 12 Sep 2007 21:42 GMT
>  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.

Simple <> Elaborate ;-)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.