How do I copy a pivotChart to paste into another doc?

[A C]

Hi

Is there a way to copy a pivotChart so it can be pasted into a word doc? Or
make it into a pic or jpg or similar? We would like it done automatically.
It would be nice to be able to edit it from in the word doc, but just as a
pic or similar would be fine for now.

Currently a pivotChart is made from the Access query, and if that report is
required the data from the query is exported into an Excel file, a pivot
chart is then made on that Excel file, and the chart then pasted into the
Word document. We would like to make the process simplier and/or automatic,
even if it just created a random word doc with the chart already in it so we
could copy and paste that into the real .doc report.

Thanks
A

 

[dbahooker]

if you were to use the 'office web components' instead of the built in
Access pivotTable crap; i believe that there is a method of the
pivotList component that will spit out a BMP or JPG or somethign along
those lines

-Aaron