Graph question-refresh

[Mr930]

I have a simple X-Y graph that uses 2 columns of data. These columns of data are just numbers in cells, and the sheet will recalculate these numbers using VBA. In this process, the range (column) is erased (new data might be shorter) and the new numbers pasted back into the column. My problem is, the erasing of the range screws up the autoscaling axis on the graph. Is there a way around this?

thanks
Fred Emmerich