Question: how to copy charts from one excel sheet to another?
Answer: The easiest way is to copy the sheet including the chart, then change the data on the copied sheet. The second-easiest way, if the chart's data is organized simply, is to use Select Data from the ribbon or the right-click menu, and change the range indicated in the Chart Data Range RefEdit at the top of the dialog.