Forum Discussion

prv_1401's avatar
prv_1401
Helper I
3 years ago
Solved

Conditional formatting for column chart is not working properly

Hi everyone,  I am facing an unusual issue in applying conditional formatting for column chart. I have attached below the images for your reference.   This is the column chart I have created  ...
Need Help
Show and Tell
Tips and Tricks
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi prv_1401 

     

    0.13 is orange, because 0.13 > 0.26*20%

     

    in the conditional format rule setting, 100% is not 1, but 100% of the max value, which is 0.26 in your case. 

prv_1401's avatar
prv_1401
Helper I
3 years ago

FreemanZ  Thanks man. I am getting it .... so what is the alternative solution to resolve this ?

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi prv_1401 

you can choose number. the dividing point is up to your expectation.