how to copy charts from one excel sheet to another?
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.