Report w/ percentile calculation

[tylerg11]

I'm trying to build a report with a graph similar to the following. I have a range of percentage values in a query. I want to build a graphical representation of this data with the Min value and the Max value. I also want the value I filtered on to be displayed between those two values, but further, I want to indicate a percentile type of representation by indicating where along the range that specific data falls.



For example, if most of the data is closer to the max, and that specific value is in that range, I want to display indicate where it falls when compared to the group. Any ideas? Thanks!

[June7]

Possible options:

1. a graph control with a single data

2. code to calculate the Top property setting of an Image control with an arrow graphic.

3. a progress bar http://support.microsoft.com/kb/304581

[Beetle]

Maybe you're after something like this? (see attached db)