How to set the color of bars in bar chart based on certain condition in google sheet?

user_15002748 0
Viewed 2244
conditional-formatting google-sheets bar-chart
1 Answers

You do it through a trick by splitting column C into two columns depending on the codition

E.g.

  1. Type into F3 =Arrayformula(IF(C3:C190>E3,C3:C190,"")) and into G3 =Arrayformula(IF(C3:C190<=E3,C3:C190,"")):

enter image description here

  1. Modify your graph by replacing the series C2:C190 by the two series E2:E190 and CF:F190:

enter image description here

user_115997890
Related