Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a bar chart which gives me a bar for the target of sales - actual sales in each department to see what the variance is.
If the bar in the chart is less than 0 i want it to be green and if the bar is greater that zero i want it to be red.
Can you tell me how to do this, this is a picture of the chart below.
So i want to make the second bar green as it is below 0.
Thanks
Laura
in expression tab on + icon of bar chart you ll see the backround color then click on it and put expression which you use for variance
in if condition
like
if(variance>0 ,lightred(),lightgreen ())
hope it helps
Hey Laura,
If you go to the expression tab and collapse the expression you can change the colour of the bars in the background colour item.
Do something like:
if(column(1)<0,green(),red())
Hopes this helps.
gr.
Frank
in expression tab on + icon of bar chart you ll see the backround color then click on it and put expression which you use for variance
in if condition
like
if(variance>0 ,lightred(),lightgreen ())
hope it helps
Hi,
See the below screen Short and attached file. You can able to add condition here