2 Replies Latest reply on Jan 9, 2014 6:08 AM by Matthew McLaughlin

    How to conditionally format color of one bar based on value of another bar

    Matthew McLaughlin

      Granted, this is a weird one...

       

      My manufacturing manager requests a dashboard to show how actual manufacturing time compares against the established standard per operation.  I have the times for actual labor and standard plotted (per operation) as bars:1-8-2014 4-09-39 PM.jpg

      We were looking to conditionally format the color of the labor time bar...if it was below the standard time, it would be green and if it was above standard time, it would be red.  Is this even possible???

       

      Thanks in advance!!

       

      Matt