Home > IT Answers > Development > How to paste data directly from Excel to Powe...
Charm
20 pts.
0
Q:
How to paste data directly from Excel to PowerPoint graphic as data using Excel VBA
VBA, Visual Basic for Applications, Microsoft Excel, PowerPoint, Excel macros, Microsoft PowerPoint
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.
ASKED: Nov 19 2008  4:53 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Labnuke99
26360 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
What about creating a link to the Excel chart that will automatically update. This tutorial discusses creating a linked object in Powerpoint from an Excel chart.
Last Answered: Nov 19 2008  5:51 PM GMT by Labnuke99   26360 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0