2 Replies Latest reply: May 13, 2015 1:31 PM by Michael Solomovich RSS

    Bar Chart where axis crosses at 1, bars below are green, above are red?

    Matt Mohon

      I'm trying to build a bar chart to show an Observed to Expected ratio.  Above 1 is bad, so bars should be red.  Below 1 is good, so bars dipping below axis should be green.  I can't quite find a guide or instructions on how to accomplish this.

       

      I have a yr-qtr dimension for the x axis.  The value examples for the y axis are such as 0.89, 1.05, 0.96 etc

       

      Any help?