Excel to powerpoint

Z

zululami

Banned
Joined
Feb 11, 2011
Messages
3,026
Reaction score
30
Location
Pub Near You
Hi guys

Perhaps I'm being overly ambitious about what technology can do.

I have a small business and Irecently did a survey featuring some 110 people via sharepoint and i managed to extract the excel spreadsheet version of their survey answers.

Now I need to do a powerpoint presentation to a bunch of potential backers to try and grow my small biz.

Please let me know if there is a way that I can export all the excel data to powerpoint and perhaps have some graphs generated, especially for the answers which required simple yes or no answers.

Thanks
 
Mmmm, how good is your Excel?

Powepoint is only really used to display the results i.e. pictures and bullet points.

The graphs you want you have to generate in Excel first and then export as pic to powerpoint.

The survery answers in table format should be easily copied and pasted into Excel if you want to display the data in table format.
 
Hi, dependent on the amount of data you want to show (i.e. rows and colimns) in your PowerPoint presentation you can directly type it in PowerPoint by inserting a table, PowerPoint will require from you the amoubt of rows and columns you want. I suggest if it is hughe amount of data, do it in Excel first then copy it and use special paste it to PowerPoint as a picture. For the graph, if you you only want to show limited data, you can do this directly in Powerpoint by using the inserting the grapgh option, else you have to do it in excel and follow same procedures as above to get it to PowerPoint.
 
Thanks guys. I am very good at powerpoint, but I totally suck on excel :( ... but i will follow through on your suggestions and see where they take me. I hope I don't have to make the graphs/pie charts etc using the spreadsheet data
 
To convert Excel Data to a chart - simply highlight the required rows & columns of your source data - press F11 - VOILA!!!! - a chart on its own sheet!

You can then copy this chart to PowerPoint as follows:

Click on top corner of chart to select it - click COPY - go to PowerPoint & create a Blank Slide - then use PASTE SPECIAL - click the PASTE LINK option on the left - then select Microsoft Excel Chart Object - then click OK - so that if you revise your source data - the PowerPoint chart will update automatically when opened.
 
Last edited:
Hi guys

Interesting topic which i have been looking at also. If you have one or two spread sheets, doing it manually is ok, but lets say you have 10 or 50 or a 100 that get updated every week. Is there no way to automate this?
 
Since Office 2007 the two are very well integrated. You can copy-paste and manipulate the source data from within Powerpoint too. Learn about the copy special functions and remember that if you're adding it to Powerpoint, it can often be difficult to read later on a projector depending on how much data there is, so plan for this by either splitting your data up or highlighting them creatively...
 
rakabos3 said:
Hi guys

Interesting topic which i have been looking at also. If you have one or two spread sheets, doing it manually is ok, but lets say you have 10 or 50 or a 100 that get updated every week. Is there no way to automate this?
Click to expand...

See my previous posting on how to automate the data updates into a PowerPoint presentation.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X