Tips for turning your Excel data into PowerPoint charts

re: Tips for turning your Excel data into PowerPoint charts

connieecoker — Fri, 28 Dec 2012 19:09:43 GMT

Thanks for this info, David. Exactly what I'm looking for--do you happen to have the full write up?

re: Tips for turning your Excel data into PowerPoint charts

moreslides — Mon, 24 Dec 2012 12:39:41 GMT

Moreslides.com is like a virtual presentation assistant for everyone who need to make their presentation wonderful. Our presentation design services range from ready to use high quality templates to highly customized animated technical presentation. These templates are fully editable in vector format which means that you can edit the shape, size, colors and text with ease. We provide a video tutorial to demonstrate how to edit the slides. Our PPTs, slides, templates and presentations are compatible with all versions of Microsoft PowerPoint. Our topic based templates range from Corporate Presentation, Investor Presentations, Project Appraisal Presentations, Gantt Charts, Equity Research Presentations, Business Proposal Presentation, Industry Report Presentations, Marketing Plan Presentation, Training presentations, Data Driven Charts, Infographics etc. We also offer customized presentations for your needs.

re: Tips for turning your Excel data into PowerPoint charts

Emily Warn — Tue, 28 Aug 2012 16:37:51 GMT

Hi David, I'm on the Office Team and like your tips! Thanks for sharing them with our readers.

Emily

re: Tips for turning your Excel data into PowerPoint charts

aviben — Mon, 27 Aug 2012 22:04:18 GMT

If you look for an automated solution capable of transferring hundreds of charts and tables in any format, it may be worth to consider an Excel add-in as EzPaste (www.EzPaste.net)

Avi

re: Tips for turning your Excel data into PowerPoint charts

datimmerman — Tue, 21 Aug 2012 21:09:34 GMT

If this is a sales & marketing deck that you plan on updating often, the last thing you want to do is be manually pasting your data into the PowerPoint chart spreadsheet!

I'd be happy to do a full write up of the process but the basic steps are:

-Make a spreadsheet that contains all of your data in a pivot table

-Create a period "guide" that tells PPT what to display

-add your chart to PPT, and in the spreadsheet it creates, link to the period guide to get the periods and use that as a reference to grab the data from the PivotTable

-Even better is if you are doing different categories of the same data, make more references that are easy to change so when you copy the chart to a new slide, you just have to open the data and type the new category to get the new data

-Use a macro to open all the charts and embedded spreadsheets to update the data for a new quarter