How can i change COLOR AREA of mini chart based on expression? My expression is like
=IF(($(TESTE_SINAL))<0, Green(), Red())
TESTE_SINAL can be between -1 and 1. But the color always return GREEN().
=IF(($(TESTE_SINAL))<0, Green(), IF(($(TESTE_SINAL)>0,Red())
nested IF, you can use any number of them according to the requirement.
Hope this helps.
I appreciated your help, but don´t work yet...
have you tried this?
=IF(($(TESTE_SINAL))<'0', Green(), Red())
Yes, i tried it too..
And i created a variable like
IF($(TESTE_SINAL)<0, Green(), IF($(TESTE_SINAL)>0,Red() ) ) l
and it return RGB(0,128,0) or RGB(128,0,0).
Bun in Chart, only draw green color....
I tried another way...
I used that variable create before as column on table and drow the color on cell backgroud, and works fine.
The problem is only mini chart bar...
Retrieving data ...