Hi - i've struggled with this for a while, so hope someone can help! I have a set of 9000 pieces of data, race results actually that I would like to show as a graph to show how an individuals performance would compare with the rest of the participants.



I have the raw data of race number, name and time, and suspect I need to manipulate this using an excel formula before it can be plotted.

Anyone help here? I was picturing a bar chart with time on the y axis and count on the x. But any suggestions on how to create most welcome!

Thanks in advance!
Mcf