Formatting of custom made Data Labels for a line chart?

Hi guys,

I've created a dynamic line chart and have added custom data labels to it.

Is there a way (I'm guessing this solution will have to have VBA in it) to change the format of custom labels to make the second word in the label a different colour?

For example, Toyota can stay the same colour while Levin is black, Camry is red and Yaris is green.

PS. I can't change the colour of the lines in the chart, they must stay the same.

Many thanks,

Stas

Re: Formatting of custom made Data Labels for a line chart?

Hi Pike,

Many thanks.

Can I ask what Excel you're using?

I tried doing that in 2013 but for some reason it highlights the whole data point label (e.g. Toyota AND Levin) and won't let me differentiate between highlighting different words. However, in 2010 I managed to do what you've pointed out.