Question

Asked:
Asked By:
Nov 19 2008   4:53 PM GMT
Charm   20 pts.

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.

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



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.
  • 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