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

    Fernando José F

      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,

       

      Fernando