3 Replies Latest reply: Jan 13, 2016 1:38 PM by Sangram Reddy RSS

    How to change the color of differents column of a Bar Chart

      Hi guys,


      I have a big issue in my Bar chart. It's setted as grouped and vertical.

      As Dimention I have the months of the year, and as measures I have the total value of three years of sales (2013, 2014, 2015).

      I'm trying to change the color of the year's columns on the chart.


      I'm trying to set:

      -2013's columns, intto grey.

      -2014's columns into blue.

      -2015 columns into yellow.


      I tried this formula, but I changes all the cloumns of the chart to blue.

      IF( Sum([2015]), yellow(), if( Sum([2014]), blue(), rgb(199, 199, 199)))

      I would like to know what's wrong in my formula and if there is a better way to do it.

      I attached a screenshot of the original chart( without the formula) and a screenshot with the formula to facilitate.

      Thanks a lot in advance.


      Best Regards,