Color Code in Chart conditional to value
I want to make a relation between a Chart Color code and a value.
eg. Won is green and Lost is red.
I can only define that the first value is green and the 2nd value is red.
If I order the values and the first value does not exist the 2nd value gets the Color of the first value.
Is there a possibility to connect the two values. I already tried to make conditioal formatting but this does not reflect the Chart Colors.
Kind Regards,