Gauge Chart - Change colors depending on characteristicas

[Manuel174102]

Hello. 

I have a gauge chart which I divided in three, red,yellow and green. 

I am selling this pieces, I have the goal and also the real sells. I want to paint it based on if I sell more than the goal or not.

But I also have to keep in mind if I select two of the pieces, I also want to apply color to the combination.

How could I do that?

For example for piece 1 I would paint it yellow, piece 2 green, piece 3 red but piece 1 + 2 it would be green.

	Goal	Real
Piece 1	5	5
Piece 2	7	10
Piece 3	3	1
Piece 1 + 2	12	15

[justISO]

Hi, have you tried

sum(Real) - sum(Goal)

[Manuel174102]

yes, but it didnt work 😞