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.