3 Replies Latest reply: May 16, 2013 4:56 AM by Kumar Natarajan RSS

    Colours of bars in bar chart

      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

      chart variance.png