Thanks - in the process of writing out my problem I thought of that approach
and have implemented that solution although it may not be the most efficient
approach - it works. I am also going to try the suggestion from Vergel
Adriano.

--
KenY


"Jon Peltier" wrote:

You could copy the pivot table, make the chart, and delete the copy of the
pivot table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"KenY" wrote in message
...
Hi
I have been writing a macro to process/reformat multiple data streams into
a
single table for analysis. Analysis is driven by pivot table and
associated
pivot chart. What I would like to do is to generate several chart views
in
sequence, grabbing a copy or picture of each chart to form a standard
report.

Problem - Excel does not allow copy/pastespecial/picture type actions on a
PivotChart.

Possible solutions with issues
1 It does not seem efficient to create the pivot table, pivot chart and
then delete the associated pivot table (as I understand 'Help' to be
telling
me I should) just to get the picture.
2 Creating multiple instances of the pivot table with different field
selections and a pivot chart associated with instance does not seem to
efficient either.

Can anyone suggest a better way?

Thanks
--
KenY