vote up 0 vote down
star

Hi

I frequently create graphs in excel 2007 for use in power point 2007 presentations. I first manipulate the chart in excel to get what I want and then cut and paste this into my ppt presentation. This works fine. However, when I change or delete this data in excel - this also changes the chart in my ppt. How to I break this linkage so that when I've created the chart I want it remains fixed?

One work-around I've found is to do a screen grab and paste this in - but this isn't a very elegant solution.

Thanks

Anthony

flag

1 Answer

vote up 0 vote down

When you paste the chart a little box should appear in the bottom right corner of the chart showing a paste icon. If you click on that box you should get a few options, including 'paste as picture' or 'Excel Chart (entire workbook)'. Either of these options will help prevent that chart changing as the original spreadsheet changes.

link|flag

Your Answer

Get an OpenID
or

Not the answer you're looking for? Browse other questions tagged or ask your own question.