1 Reply Latest reply on Jul 17, 2013 8:57 AM by Gengming Chen

    Conditional Formatting on Bullet Graph

    Nora Kelmendi

      Hi all,


      I have a bullet graph with the blue bars showing acceptances and the black line showing the target. Is it possible to make the bar change colour once it has reached the target?


      Kind Regards,


        • 1. Re: Conditional Formatting on Bullet Graph
          Gengming Chen

          The easiest way would be creating a new calculated filed. This filed will just be a logical statement (e.g., IF barFiled > ReferenceLine THEN 1 ELSE 0 END). Drag this filed to color card (now, 1 or 0 from the created filed will correspond to a different color accordingly). Edit the color to your like. That should do it.

          1 of 1 people found this helpful