The problem with copied Excel charts and data

I often customise a chart, then copy both chart and data to another area ready for new data. I then amend the copied data, e.g. to show sales of a different business. If you do this too, you will enc...