Home > IT Answers > Development > How to paste data directly from Excel to PowerPoint graphic as data using Excel VBA
Charm
20 pts.
 How to paste data directly from Excel to PowerPoint graphic as data using Excel VBA
Excel macros, Microsoft Excel, Microsoft PowerPoint, PowerPoint, VBA, Visual Basic for Applications
I've been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual existing graph and paste the data in. I have to do this for 20 graphs and for multiple iterations....Any help would be greatly appreciated.

Software/Hardware used:
ASKED: November 19, 2008  4:53 PM
UPDATED: November 19, 2008  5:51 PM
RELATED QUESTIONS
Answer Wiki:
What about creating a link to the Excel chart that will automatically update. <a href="http://learngen.org/resources/leobjects/lg0007ta.html">This tutorial</a> discusses creating a linked object in Powerpoint from an Excel chart.
Last Wiki Answer Submitted:  November 19, 2008  5:51 pm  by  Labnuke99   32,645 pts.
All Answer Wiki Contributors:  Labnuke99   32,645 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _