Question: how do i copy a chart from one excel spreadsheet to another?
Answer:  Right Click on the sheet where the original chart and data series are stored.
 Click on Move or Copy…
 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.