Forum Discussion

Tarunika's avatar
Tarunika
Icon for Helper II rankHelper II
3 years ago
Solved

how can i achieve Conditional formatting for a clusterd column chart

hi ,  I have a requirement where the colour of the bars in a clustered column chart should be changed based on the percentage i.e if >95% than green ,75%-94% than orange,50%-70%than yellow and less ...
  • DoubleJ's avatar
    3 years ago

     

    In formatting pane go to "Columns - Colors" and click "conditional formatting":

     



    Set the rules:

     

     



    Hope this helps
    JJ