What if I DON'T want the chart to be updated when source data changes?

[arhooley]

I'm using a huge spreadsheet to create a series of charts. I need to
re-sort the *entire* spreadsheet for each chart I create, which causes
all the previous charts to change. How can I create a chart, "freeze"
it, and then go on to create more charts from different data on the
same spreadsheet?

 

[bj]

the easiest way to do it is to copy the chart as a picture (hold
shift)<edit><Copy as picture>and paste the picture in a sheet.
the other way to do it is to create a new copy of the data sheet for each
chart you need to make.

 

[Jon Peltier]

I wrote a page about delinking your chart from its data range:

http://peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html

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