Moving a chart from one workbook to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top