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

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
_______


"Dixie" wrote in message
...
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

Thanks Jon that works perfectly.

"Jon Peltier" wrote:

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
_______


"Dixie" wrote in message
...
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