4 Replies Latest reply on Dec 19, 2016 9:23 PM by Mohammad Said

    Highlighting (color coding) a bar chart

    Mohammad Said

      Hi folks.

       

      Need some advice on highlighting (or color coding) bar charts according to highest or lowest value. For example, I want the highest (or max value) to be highlighted in green while the lowest (min value) in red. The remaining bars can remain blue in colour.

       

      Highlighting a bar chart.JPG

       

      Have tried using filters and Max/Min formula but it does not give the expected result. There is another way of doing it by sorting them. However, it is something that we do not want. We just want to see by its original view (the max and min colours come automatically). Appreciate if anyone can share some tips and tricks to achieving the above.