1 Reply Latest reply on Nov 1, 2018 11:54 PM by lei.chen.0

    Color Coding on Bar Dynamically

    Prakash Desai

      Hey Guys,

       

      I think i am doing something wrong and not able to make it work. Can you please help me here.

       

      If Grey bar % value is less than Blue bar then value of Grey bar should be displayed in Red dynamically.

      If Grey bar % value is Greater than Blue bar then value of Grey bar should be displayed in Green dynamically

      Blue bar can be in the same color(black).

       

      Along with the above scenario, I have another scenario. Is this possible dynamically in a single sheet?

      If Grey % is <=50% of Blue bar % then Red

      If Grey % is >55% and <=80% of Blue Bar then Yellow

      If Grey % is >90% of Blue Bar then Green

       

      Thanks,

      Prakash.