Count cells in chart depending on color

[ahmedhali]

Hi

I have a question regarding charts. Is it possible to count chart cells depending on whether they are green or red? For example in the chart below the expression would say there is 2 green on the second row and 3 on the first.

Thx in advance!

[ahmedhali · Accepted solution]

Hi

I solved this by taking the expression that makes the coloring and changed the true and false statement from color to 1 and 0. Then I proceeded to add them together. For example

if(sum(column(1)+column(2))>=column(3),1,0)

+

if(sum(column(4)+column(5))>=column(6),1,0)

Maybe not the best solution but it got the job done. Hope this will be relevant for anybody

/Ahmed