How to paste data directly from Excel to PowerPoint graphic as data
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
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 graph and paste the data in. Any help would be greatly appreciated.
ASKED: Nov 15 2008  5:05 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
JP2112
475 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
If you press and hold the Shift key while you go to the Edit Menu, an option called "Copy Picture" appears. Then you just switch to your PPT application and Paste (Ctrl-V). In VBA, use the Range.CopyPicture Method. --JP



Have you tried the Paste Special ... command? Typically under Edit menu.
Last Answered: Nov 16 2008  2:07 PM GMT by JP2112   475 pts.
Latest Contributors: DLLevine   15 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0