Hi Pete,

Thank you for your reply. Unfortunately, it doesn't quite address the whole problem.

I am trying to avoid manually changing the title of each chart each time I create a new one. So, I am hoping for a way to template the chart such that it pulls its title from the correct location.

It seems to me that there is a similar idea in copying cells from one place to another. When I copy cells from column B to column D, the new cells in column D will not pull data from the same location that the original cells (from column B) pulled from. Rather, they will pull their information from cells that are positionally equal to column D.

I hope this makes sense. Please let me know if I need to clarify things any further.