How to paste data directly from Excel to PowerPoint graphic as data using Excel VBA

20 pts.
Tags:
Microsoft Excel
Microsoft Excel macros
PowerPoint
VBA
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

What about creating a link to the Excel chart that will automatically update?

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: