Copying graphs

[Dixie]

Hi Is it possible to range value a graph ie I would like to copy the graph to
another workbook, show all the information but without the links?

Thanks

 

[Jon Peltier]

You could copy the chart as a picture, then paste it wherever you want.
Select the chart, hold Shift while clicking on the Edit menu, Choose Copy
Picture, and select the On Screen and As Picture options, then go to the
other workbook/sheet and Paste.

- Jon

 

[Dixie]

Thanks Jon that works perfectly.

You could copy the chart as a picture, then paste it wherever you want.
Select the chart, hold Shift while clicking on the Edit menu, Choose Copy
Picture, and select the On Screen and As Picture options, then go to the
other workbook/sheet and Paste.

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