Excel Chart Question

[tony3141]

Is there a way to stop excel from automatically updating a chart you have created when you change the data series that created that chart? Say you create a chart using certain columns and rows, then write over those same columns and rows with different data and create a new chart. As far as I can tell, both charts will update automatically with the new data and you end up with two identical charts. Maybe this is just the way Excel is designed and there is no way around it. One option I've thought of is saving the graph as a picture each time before the data is overwritten by my macro. Thoughts?

 

[stevebausch]

You could copy and Paste-Special-Values the data source to someplace else, then reset the DataRange to that new location.