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 11 2008  11:46 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
SbElectric
1575 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
I may be missing something from the question. The good-old CTRL+C and CTRL+V works between Excel & PowerPoint.

If you want to place only the chart from Excel then ... highlight the graph & copy by holding down Ctrl +C. Now on the PowerPoint slide click on the area that you want the graph to be placed & then paste (Ctrl+V). You can now re-size & move the graph by clicking on the graph & then moving the “handles”. The underlying data for the chart is automatically copied. If you want to change the data in PowerPoint then right click on the chart & select “Edit Data”. Excel like page will open up - you can change the data & dynamically can see the effect on the chart.

It seems complicated ... but it is fairly easy. My description may be too verbose. This is true in Excel 2007 & PowerPoint 2007. I am sure it is very similar is 2003 version. You are welcome to post again if further questions. Good luck.
Last Answered: Nov 18 2008  3:26 PM GMT by SbElectric   1575 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

IT Knowledge Exchange Community Update for 11/18/08 - ITKE Community Blog   0 pts.  |   Nov 18 2008  4:14PM GMT

[...] >> How to paste data directly from Excel to PowerPoint graphic as data [...]

 
0