Another option is to copy the chart as a picture and paste it back. Hold
Shift while clicking on the Edit menu, and Copy becomes Copy Picture.
Select the options that give you the best appearance; I like the On
Screen and Picture options for most cases.

Roger's approach allows the chart's elements to be reformatted (colors,
fonts, etc.) although the data is harder to change. My method only
allows the user to resize or delete the chart.

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

sharprog < wrote:
sorry hit wrong key ... here is rest of reply

after F9 you will see the array formula instead of the normal range
notation.

The graph is frozen.

NB This does NOT toggle back with another F9

I think that you would have to redefine the source data to get back to
Square 1.

It may be OK for you to save the Frozen version with another name, and
then continue with the original ?


If you want this done in VBA you need another helper :)

best regards .. Roger


---
Message posted from http://www.ExcelForum.com/