I have a worksheet with currency and a chart. If I want to copy this to another worksheet and change the values from say USD rates to EUR rates, the chart STILL reads the source data of the first worksheet. This means taking forever manually re-selecting the data source.

Is there a simpler way to clone a worksheet moving all data and chart functionality to a 'new environment'?