Question

Asked:
Asked By:
Nov 11 2008   11:46 AM GMT
Charm   20 pts.

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.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Development and Microsoft Windows.

Looking for relevant Development Whitepapers? Visit the SearchWinDevelopment.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

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 [...]