Copy chart with reference table

[Arun]

I have a pie chart neatly tied to a data table alongside. Now I want to copy
both the chart and table to a different area of the sheet so I can modify the
new data table and have 2 different charts.

My issue is that the chart will only allow absolute references, so when I
copy both the chart and table together the new chart still is tied to the old
table - so I have to go and change the source data ranges one by one.

Any way that I can do this easily?

 

[Jon Peltier]

Copy the whole sheet. The copied chart links to the data on the copied
sheet. Now cut the range that includes the copied chart and its data,
and paste it back onto the first sheet. Finally delete the copied sheet.

- Jon