Creating chart title with VBA words with different colours

[lionelv]

Can someone point me in the right direction how I change the fonts of
specific words in a chart title using VBA?

Thanks

Lionel.

 

[lionelv]

Nevermind. I discovered macro recording and found that you do it via
chart.ChartTitle.Characters(startindex, endindex).Font