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

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

Answer Wiki

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

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.

Discuss This Question: 1  Reply

 
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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Charm
    [...] >> How to paste data directly from Excel to PowerPoint graphic as data [...]
    0 pointsBadges:
    report

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following