MS Excel / VBA help thread

You are reading a single comment by @Chalfie and its replies. Click here to read the full conversation.

•

aggi

A PowerBI formatting question. I've got a scatter chart with a fair few data points on there. The points are multi-coloured but the category labels are pretty congested so it's hard to tell which label relates to which point. I'd like the labels to be in the same colour as the points rather than black to make it easier to tie them up.

This is an example of the kind of thing, how do I make the colour of the player names match the circles? Cheers

•

Chalfie in reply to @aggi

Are the category colours auto generated?
otherwise it could be the same sort of methodology as a date table?
so you build a table of all the player names, write a formula to assign a colour to their name in another field. then link by a relationship?
is that making sense?

•

aggi in reply to @Chalfie

Auto generated (although they don't have to be).
I just can't see an option to assign more than one colour to the text, not sure if I'm missing something. I can'#t find anyone asking the question online which seems surprising so not sure if I'm using the wrong terms.

About

Avatar for Chalfie @Chalfie started