topic Re: Bar Chart where axis crosses at 1, bars below are green, above are red? in QlikView https://community.qlik.com/t5/QlikView/Bar-Chart-where-axis-crosses-at-1-bars-below-are-green-above-are/m-p/853636#M470588 <HTML><HEAD></HEAD><BODY><P>Figured it out lol.</P><P></P><P>Had to subtract 1 from my ratio (ratio-1)</P><P>had to offset my expression by 1</P><P>had to color based on expression.</P></BODY></HTML> Wed, 13 May 2015 16:53:54 GMT 2015-05-13T16:53:54Z Bar Chart where axis crosses at 1, bars below are green, above are red? https://community.qlik.com/t5/QlikView/Bar-Chart-where-axis-crosses-at-1-bars-below-are-green-above-are/m-p/853635#M470587 <HTML><HEAD></HEAD><BODY><P>I'm trying to build a bar chart to show an Observed to Expected ratio.&nbsp; Above 1 is bad, so bars should be red.&nbsp; Below 1 is good, so bars dipping below axis should be green.&nbsp; I can't quite find a guide or instructions on how to accomplish this.</P><P></P><P>I have a yr-qtr dimension for the x axis.&nbsp; The value examples for the y axis are such as 0.89, 1.05, 0.96 etc</P><P></P><P>Any help?</P></BODY></HTML> Wed, 13 May 2015 16:46:54 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-where-axis-crosses-at-1-bars-below-are-green-above-are/m-p/853635#M470587 2015-05-13T16:46:54Z Re: Bar Chart where axis crosses at 1, bars below are green, above are red? https://community.qlik.com/t5/QlikView/Bar-Chart-where-axis-crosses-at-1-bars-below-are-green-above-are/m-p/853636#M470588 <HTML><HEAD></HEAD><BODY><P>Figured it out lol.</P><P></P><P>Had to subtract 1 from my ratio (ratio-1)</P><P>had to offset my expression by 1</P><P>had to color based on expression.</P></BODY></HTML> Wed, 13 May 2015 16:53:54 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-where-axis-crosses-at-1-bars-below-are-green-above-are/m-p/853636#M470588 2015-05-13T16:53:54Z Re: Bar Chart where axis crosses at 1, bars below are green, above are red? https://community.qlik.com/t5/QlikView/Bar-Chart-where-axis-crosses-at-1-bars-below-are-green-above-are/m-p/853637#M470589 <HTML><HEAD></HEAD><BODY><P>Like in attached?</P></BODY></HTML> Wed, 13 May 2015 17:31:24 GMT https://community.qlik.com/t5/QlikView/Bar-Chart-where-axis-crosses-at-1-bars-below-are-green-above-are/m-p/853637#M470589 Anonymous 2015-05-13T17:31:24Z