I recorded a simple macro to do just that but when I run it, it throws an error on to the second line : "Method 'TextFrame2' of object 'ChartFormat' failed"
.Fill.ForeColor.RGB = RGB(0, 0, 0)
.Bold = True
How should it be written?
Also, how should I write it so that it will perform the same operation on all the charts on the sheet. There are numerous other shapes on the sheet.