This content has been marked as final. Show 3 replies
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.