Which chart is suitable to present Distribution data across the scoring like 0-4,5-10,10-20

[narayanaqlik]

Hi All,

I have a requirement like to present all risks below 4 score should appear with green color and all to gather in the same place(Not count of risks) means all those should appear 0-4 score rage of X-axis and 5-10 score risks in between 5-10 score and amber color, 10-27 above score red color

[andoryuu]

I'm partial to colormix2 which will give you a color range for your three sections to show a little more accurately the shift from one area to another.  You have to get your values normalized to be from -1 to 1 so I'd recommend this:

Colormix2(((RiskValue * 2) / 20) -1),green() , yellow(), red())

note this assumes your stated range of 0 to 20 being normalized to -1 to 1 and will give you a range or colors.  If your users need just three discrete colors you can do if statements thusly:

Colormix2(if(RiskValue<5,-1, if(RiskValue<11,0,1)),green() , yellow(), red())

Based on your stated business requirement a histogram will show a distribution of a single metric.  If you'll be doing this for multiple categories you could use a distribution plot.