Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to colour the bars of chart in colour Green (for consumption less than 850)and the rest of colour of same bar in red (for consumption more than 850).
So for "03 Tankroom" , bar should be both in green(for <=850) and red(1911-850) color. and other two bars should be in Green color.
Could some one let me know how to achieve this?
Thanks in advance
Just create two expressions in your graph (assuming Sum(Value) is your expression):
if(Sum(Value) <= 850, Sum(Value), 850)
and
if(Sum(Value) > 850, Sum(Value) - 850, 0)
Additionally, you must select the option for stacked display, on Style Tab, Stacked Subtype.
Then, simply define a color for each expression in the Colors tab.
Just create two expressions in your graph (assuming Sum(Value) is your expression):
if(Sum(Value) <= 850, Sum(Value), 850)
and
if(Sum(Value) > 850, Sum(Value) - 850, 0)
Additionally, you must select the option for stacked display, on Style Tab, Stacked Subtype.
Then, simply define a color for each expression in the Colors tab.
Thanks a lot Rodrigo!
It worked