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.
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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.