Other Techniques to Copy an Excel Chart and Change the Data Reference
What if you only have a few data points in your chart and want to make a copy and change the data reference? This post describes a few other techniques that you can use to easily Copy a Chart and Change the Data Series Range References.
In a previous video, we learned how to copy a chart in Excel quickly and have it reference a new chart data range on the same worksheet. If you missed it, you can check it out here:
http://www.exceldashboardtemplates.co...