Single Column Ranking Chart

[SusieQ222]

I have peer values that I want to rank in a single column to benchmark them against each other. I would also like these to include percentile ranks of the overall peer group, but I want the chart to include only values over a certain level. For example, these are some of the values I want to compare that I have analyzed in a pivot:


[TABLE="width: 397"]
<TBODY>[TR]
[TD]Activity Rate</SPAN>[/TD]
[TD](Multiple Items)</SPAN>[/TD]
[TD]1.0%+</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sum of Activity Rate</SPAN>[/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Agency</SPAN>[/TD]
[TD]Total</SPAN>[/TD]
[TD](Count)</SPAN>[/TD]
[TD](Rank)</SPAN>[/TD]
[/TR]
[TR]
[TD]AAAA</SPAN>[/TD]
[TD="align: right"]1.7%</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BBBB</SPAN>[/TD]
[TD="align: right"]1.7%</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD="align: right"]2</SPAN>[/TD]
[/TR]
[TR]
[TD]CCCC</SPAN>[/TD]
[TD="align: right"]1.6%</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DDDD</SPAN>[/TD]
[TD="align: right"]1.2%</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EEEE</SPAN>[/TD]
[TD="align: right"]1.1%</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FFFF</SPAN>[/TD]
[TD="align: right"]1.1%</SPAN>[/TD]
[TD="align: right"]1</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Grand Total</SPAN>[/TD]
[TD="align: right"]0.082233439</SPAN>[/TD]
[TD="align: right"]6</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD](Total Population)</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]49</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL span=2></COLGROUP>[/TABLE]


I care about benchmarking BBBB against their peers, as well as within the overall group. What I want is a single column that shows the overall population, a different color section of the bar for cases above my threshold, and a percentile rank for where they fall against their peers. Can this be done with my pivoted values, and if it can, how do I go about making these charts to include in my reports?

Thanks for your help.