Jon Peltier wrote:
Let's say you have two sheets, the "Data" sheet which keeps refreshing and
the "Archive" sheet where you will store old data.

You can set up an event procedure on the Data worksheet. Right click the
Data worksheet tab and choose View Code. In the module that pops up, choose
Worksheet from the left dropdown, and Calculate from the right. This code
appears:

Private Sub Worksheet_Calculate()

End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub

Delete the second pair of lines:

Private Sub Worksheet_Calculate()

End Sub

Almost there, but I'm really confused about the above statement.

The following code comes first?

Private Sub Worksheet_Calculate()

End Sub

What code do I delete?

Can I delete the original graph on the 'Archive' worksheet once it has
been copied to the 'Data' worksheet?

No values have been copied across in my example even though I have
checked the data and naming. I'll have to re-check or start again if
you can answer my query and see if that helps.

Do you have an example on your website?

Thanks.