Creating a salary band penetration graph

[kanushreeprasad]

Hello, need help in creating a band penetration graph for salary please.
I got the box and whisker plot(the blue bit) but can't seem to plot where the individuals salary is (the red point). attached a sample of what I would like to create.
For example:
P25: Usd 125
P75: Usd 500
I get the box and whiskers plot for this. However, I would want to on this plot the individual's salary to show where it lies on the band. How can I integrate this?

 

[awoohaw]

The image is nearly illegible. Can you post the data for this so the forum can use that to work on your solution? The xl2bb add in (Link Below) is great for this. If you can't use that add in then please post the data in a table. An image of your data is not really preferred. The xl2bb will not copy the chart though, so an image of that is all you can do.