Sometimes, for reporting or exploration, you need to create tens to thousands of identical charts in Excel. The best way to do this is to have a single chart, and repeatedly change the data that’s underneath the chart.
We’ll be showing you some powerful techniques for doing this in upcoming weeks, but today we want to get started by showing how to dynamically change graph titles as the underlying data changes.