chart from large data set
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
|