1) Right Click on the sheet where the original chart and data series are stored. 3) Check the “Create a copy” checkbox. If you want to make a similar chart in another workbook, change the “To book:” to the other workbook that you want this Excel Dashboard Chart to be copied.