Protect old chart when updating data series for new chart

[tony3141]

I have a macro that puts data into a group of cells and then creates a chart. It then gets new data, puts it in the same spot and creates another chart. The problem is that the first chart changes since it's data series is linked to those cells. I don't want to save the numerical data in the cells, but I do want to have a chart of the data from each data pull. I am pulling 50 to 100 different sets of data each time and when I finish I would like 50 to 100 different charts. Is there a way to make the chart locked so that it can't be changed when the cells it references change?

 

[johnpdavey]

just a thought
if you can copy the chart and paste it into word (not paste link)then it wont change if the data changes

 

[seacrest]

Try ThisSub
sub auto_open()
Application.Calculation = xlCalculationManual
End Sub