Go Back   PCMech Forums > Help & Discussion > Software Discussion & Support

Need Some Help? Type Your Keywords Here:

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
Old 05-08-2009, 03:14 AM   #1
Member (9 bit)
 
Join Date: Sep 2001
Location: London UK
Posts: 421
Excel data to Powerpoint

Hi - sorry if this question isn't very 'pcmech' but you guys normally have an answer!

My gf deals with research data, which comes in the form of huge excel spreadsheets. All the data is in tables which are repeated and maintain the same format throughout. From these, she has to prepare Powerpoint presentations. She has to manually copy the data from the spreadsheets into powerpoint, to prepare the charts, which takes her days.

Now, I'm no expert when it comes to these products, but I can't help thinking that they must be cleverer than that. Surely Powerpoint is able to take Excel data and produce a basic chart from it, which can then be tailored to your liking?

Any pointers would be greatly appreciated.
NBee is offline   Reply With Quote
Old 05-08-2009, 04:06 AM   #2
glc
Forum Administrator
Staff
Premium Member
 
glc's Avatar
 
Join Date: May 2000
Location: Joplin MO
Posts: 37,785
Open the PowerPoint presentation into which you wish to import data from an Excel spreadsheet.
Choose "Insert > Object" to display the Insert Object dialog box.
Choose "Create from file" and click the "Browse" button to locate the Excel workbook that contains the data you wish to import.
Click "OK" to insert the object onto the slide.
Resize the object if necessary to fit the proportions of your slide.
glc is offline   Reply With Quote
Old 05-08-2009, 06:29 AM   #3
Member (9 bit)
 
Join Date: Sep 2001
Location: London UK
Posts: 421
Thanks GLC - I've passed the info on so hopefully it will be of some help.
NBee is offline   Reply With Quote
Reply

Bookmarks

Still Need Help? Type Your Keywords Here:


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 09:45 PM.
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
SEO by vBSEO 3.6.0 PL2