Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
I have bar chart and I want the colour of the bars to change, dependant on the value.
So on the expressions tab, in Background colour if result is Less that 45, Orange, BETWEEN 45 and 50 go Green and greater than 50 go red.
I have tried the below, and it does not go red at all.
Can anyone see where my issue lies?
Thanks
A
if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])<45, RGB(255,128,0), |
if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])>45, RGB(0,191,0), |
if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])<50, RGB(0,191,0), |
if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])>50, RGB (255,0,0))))) |
Try
if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])<45, RGB(255,128,0),
if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])<50, RGB(0,191,0), RGB (255,0,0)))
Try
if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])<45, RGB(255,128,0),
if(Sum({< Activity -= {'*Funding Sheet*'} >} Number)/sum([Team Members for Flexcube processing])<50, RGB(0,191,0), RGB (255,0,0)))
Thanks Daniel