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
  • No. I manually entered data in format like 0.05 so when I convert to percentage it is 5%. 

  •  

So it's manually entered data.

FreemanZ's avatar
FreemanZ
Super User
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.