Paste Chart Word, PPT, as a CHART, UN-link data

Solar-Greg

New Member
Joined
Mar 1, 2012
Messages
1
Hello all! Long time lover of Mike and Bill..

Okay.. I would like to paste a pivot table chart into Word (or PPT), BUT maintain the benefits of chart functionality AND not have the chart update each time I adjust the pivot table.

FYI, I've already seen the trick here: http://youtu.be/EakBrAzC1WA
Unfortunately the F9 trick to insert "source data" into the chart (aka, un-link to cell references) does not work; I get an error after evaluating the "source data" components of the function. Erg.

So yes, every time I updated the pivot table chart (say, look at a different variable), it still impacts the chart in the Word or PPT program.. I really prefer *not* to paste as an image (it's much more convenient to paste with chart manipulation functionality).

Any thoughts please! Thanks all.
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,102,288
Messages
5,485,912
Members
407,523
Latest member
Talicius

This Week's Hot Topics

Top