I got numerous charts with the following user-defined names: MyChart_01, MyChart_02 … MyChart_15 etc. (less than 100 charts). All of them do not have any chart titles.
The cells where the chart titles reside are all named: ChartTitle_01, ChartTitle_02, ChartTitle_03. The suffix numbers correspond with the respective suffix numbers of the chart
Based on the above facts, I would like to automatically add chart titles using VBA ...
i.e. MyChart_01 will get the chart title from the named cell 'ChartTitle_01',
'MyChart_02' will get the chart title from the named cell 'ChartTitle_02' etc.
The named cell ranges of the chart titles are all in one column and in sequential order.
I wonder whether the matching up of chart titles and charts would also be possible if the chart titles would not be in any logical order?
Help is much appreciated. Thank you very much in advance.
I have attached a sample file for your convenience.
Regards, Andreas ChartTitle-Create-For-All-Charts.xlsm