Copy Excel charts to PowerPoint slides 1

[AgatheB]

Is this possible? And if yes, is there anybody that could provide me with some code examples...

Thanks,
Agathe

 

[MichaelRed]

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

 

[Chattin]

Here you go

http://www.geocities.com/jonpeltier/Excel/XL_PPT.html

HTH

Chris ;-)

Visit

http://www.mrexcel.com/board/index.php

for great xl and xl/VBA help

 

[RobBroekhuis]

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

 

[Queryman]

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

 

[vb6novice]

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.

 

[Queryman]

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

 

[AgatheB]

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

Agathe