Below macro adds a DYNAMIC chart title to the first chart using a NAMED cell range. The named range in the below code example is 'ChartTitle_01' (workbook-level name)
I would like to get below code changed to accomodate the following requirements:
All Charts in my workbook are named as follows: Chart_01, Chart_02, Chart_03 etc.
The chart titles are all named ranges as follows: ChartTitle_01, ChartTitle_02, ChartTitle_03 etc.
So the macro should loop thru all the charts and add Chart Titles using the named range.
Could someone please help me with this?
Help is much appreciated. Thank you very much in advance.
I have attached a sample file for your convenience.
.HasTitle = True
.ChartTitle.Text = "=PieCharts!ChartTitle_01"