I am creating a file that is updated on a monthly basis and then used to
populate sub-reports. I use a macro to paste special the values, formats,
and widths into the sub-reports so the user does not have to update the file
each time they use it. I would like to include a graph from the main file in
the sub-reports.

Is there a way to paste just the graph and not the underlying links, like
using a paste special values command, into the sub-report? I would like to
show the "picture" of the graph.

Thanks

Dave,

To copy the chart as a picture, click on the chart (activate it). Press the
Shift key and go to Edit - Copy Picture. Choose the picture option that you
want, activate a cell somewhere else in your worksheet, and hit Edit - Paste.

Assuming your chart is called "Chart 1", the macro recorder returns . . .

Sub CopyPicture()
ActiveSheet.Shapes("Chart 1").Select
Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture
Range("A1").Select
ActiveSheet.Paste
End Sub

----
Regards,
John Mansfield
http://www.pdbook.com


"Dave" wrote:

I am creating a file that is updated on a monthly basis and then used to
populate sub-reports. I use a macro to paste special the values, formats,
and widths into the sub-reports so the user does not have to update the file
each time they use it. I would like to include a graph from the main file in
the sub-reports.

Is there a way to paste just the graph and not the underlying links, like
using a paste special values command, into the sub-report? I would like to
show the "picture" of the graph.

Thanks