Prev: powerpoint text comes up all at once, i need it one line at a time
Next: I NEED HELP to repeat a cycling of photos on one slide...
From: PsyberFox on 9 Mar 2010 09:32 Hi there, I have a pivot chart in Excel and want to copy this to Powerpoint. Copy>Paste obviously works fine but as soon as I change the pivot table feeding the chart, e.g. adding row data it updates the chart in powerpoint. How can I prevent this from happening as I want to copy>paste different variations of the pivot chart into one powerpoint presentation? As soon as I do this it updates all graphs in the presentation to whatever the pivot chart is showing at that time... Thank you for any help! W
From: Steve Rindsberg on 10 Mar 2010 11:11
In article <D77A8CB0-C1C5-47BD-8401-6D6658239842(a)microsoft.com>, PsyberFox wrote: > Hi there, > > I have a pivot chart in Excel and want to copy this to Powerpoint. > Copy>Paste obviously works fine but as soon as I change the pivot table > feeding the chart, e.g. adding row data it updates the chart in powerpoint. > How can I prevent this from happening as I want to copy>paste different > variations of the pivot chart into one powerpoint presentation? As soon as I > do this it updates all graphs in the presentation to whatever the pivot chart > is showing at that time... It's always wise to mention the version of any programs you're using; the answer may depend on which version you have. I'm guessing you have PPT 2007. In that case, instead of pasting, use the down arrow next to the Paste button and choose Paste Special. Choose either a picture format or an Excel object but make sure that "Link" is UNCHECKED. If you choose a picture format, you won't be able to doubleclick and edit it in Excel. If you choose an Excel format, you will be able to edit it, but the presentation will be much larger (file size). ============================== PPT Frequently Asked Questions http://www.pptfaq.com/ PPTools add-ins for PowerPoint http://www.pptools.com/ |