I am trying to create a bar chart with six different calculated fields where all my actual's have to be in blue , budgets have to be in yellow and the variance should be in either red (if negative value) or green (if positive value). I have manually edited the colors in my report which you can view in the image attached and when I try to create a calculated field for variance it is effecting all the bars in the view.
Could anyone help me in achieving my requirement??
In the following the image the variance is in green color which has to be in red.