Copy/paste chart settings with VBA

It can be very tedious to prepare many charts for a report: the charts must have consistent formatting and may repeat some of the same data. Making charts consistent is a long, iterative process: select one chart, note the data or settings you want to copy, select another chart, apply the data or settings, repeated ad nauseum. This presentation shows how to use VBA to make this process faster, easier, and less prone to error.