export Pivot Charts to MS Word?
 

Can this be done? I'll have several charts to go to several Word docs and
would like to avoid the copy/paste option.

export Pivot Charts to MS Word?
 

copy the pivottable to your clipboard. Open Word choose Edit, PasteSpecial.
On the Paste Special Window choose Paste Link and Microsoft Excel Worksheet
Object. Realize that this could cause you to have a very large Word doc.

"srpd" wrote:

Can this be done? I'll have several charts to go to several Word docs and
would like to avoid the copy/paste option.

export Pivot Charts to MS Word?
 

Thanks for your help, but it's not the Pivottable I want to put into Word but
the PivotCharts. There will be 150+ and I was hoping for some sort of export
/merge mechanism. The data in the tables will not be in the final Word report.

"RussellT" wrote:

copy the pivottable to your clipboard. Open Word choose Edit, PasteSpecial.
On the Paste Special Window choose Paste Link and Microsoft Excel Worksheet
Object. Realize that this could cause you to have a very large Word doc.

"srpd" wrote:

Can this be done? I'll have several charts to go to several Word docs and
would like to avoid the copy/paste option.