Chart Challenge!

[SusieQ222]

I am trying to get a chart to display pivoted peer values within a single column. I want the column to represent the spectrum of percentages, with a highlighted section for values over a certain threshold level. I'd also like to include a percentile rank, if this is possible. Is there any way to do this? Thanks for your help.

My values I want to chart are as follows, and the Location I am trying to compare is BBBB:
[TABLE="width: 500"]
<TBODY>[TR]
[TD][TABLE="width: 407"]
<TBODY>[TR]
[TD]Activity Rate</SPAN>[/TD]
[TD](Multiple Items)</SPAN>[/TD]
[TD]1.0%+</SPAN>[/TD]
[TD](TH)</SPAN>[/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]Location</SPAN>[/TD]
[TD]Total</SPAN>[/TD]
[TD](Count)</SPAN>[/TD]
[TD](Rank)</SPAN>[/TD]
[/TR]
[TR]
[TD]AAAA</SPAN>[/TD]
[TD]1.7%</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BBBB</SPAN>[/TD]
[TD]1.7%</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[/TR]
[TR]
[TD]CCCC</SPAN>[/TD]
[TD]1.6%</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DDDD</SPAN>[/TD]
[TD]1.2%</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]EEEE</SPAN>[/TD]
[TD]1.1%</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FFFF</SPAN>[/TD]
[TD]1.1%</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Grand Total</SPAN>[/TD]
[TD]0.082233439</SPAN>[/TD]
[TD]6</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD](Total Population)</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD]49</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL span=2></COLGROUP>[/TABLE]
[/TD]
[/TR]
</TBODY>[/TABLE]