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?