Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy Excel charts to PowerPoint slides 1

Status
Not open for further replies.

AgatheB

Programmer
Jan 16, 2003
36
DK
Is this possible? And if yes, is there anybody that could provide me with some code examples...

Thanks,
Agathe
 
It is at least possible to copy the 'source' of the data to PP and have PP generate the chart. It has been a while since I did this and either do not have or at least cannot find the example, but I do recall attempting to copy just the chart image and having MUCH more trouble than with the data. AFAIK, the only references I needed were in the ubiquitous {F1} (aka help) system(s) and some experimenting.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places
 
You can copy as a picture (as per the geocities link above), or in a graphics format such as jpg, whichever works best for you.


Rob
[flowerface]
 
There are a few ways to do this:
1. Copy and paste as picture
2. Do a paste link of the chart from excel to ppt
3. Use an embedded object in ppt to update the chart.

I have used all three and number 3 is my favorite method, because there is no link between ppt & excel, but the chart can still be changed.



Michael

 
I agree with QueryMan. Embedding the object in ppt is the best way to go because it causes the fewest unwanted changes to formats and things like that. Plus you can always break the link after you embed the chart.

I have dozens of ppt's that I produce monthly from a linked ppt file. Each month I update the Excel data, open the ppt and answer Yes to the "The presentation XYZ contains links. Do you want to update now?" question, and then save it as the previous month's presentation. Then I just break all the links so that when I e-mail the ppt to the department, they don't get the update question and can't screw up my data.
 
You can actually take it a step further and paste a msoobject in ppt which is an excel chartsheet with a data sheet behind it and just update the data sheet. This way you have a standalone ppt with excel charts, but the charts can still be changed and there are no links to break.



Michael

 
Thanks all of you! I used the link Chattin came up with and copy as picture.

Agathe
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top