Graphing swimmers' times over time

[petersw]

Hi,

I'm trying to create a graph that compares several swimmers time at different meets. The data is stored as follows:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Swimmer A[/TD]
[TD]Swimmer B[/TD]
[TD]Swimmer C[/TD]
[/TR]
[TR]
[TD]1/1/2018[/TD]
[TD]01:53.55[/TD]
[TD][/TD]
[TD]01:50.51[/TD]
[/TR]
[TR]
[TD]6/5/2018[/TD]
[TD]01:34.22[/TD]
[TD]01:45.12[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7/9/2018[/TD]
[TD]01:30.10[/TD]
[TD][/TD]
[TD]01:35.12[/TD]
[/TR]
</tbody>[/TABLE]

I know times must be formatted in Excel as mm:ss.00, but I'm struggling with how to graph all this info. I think Dates should be on the X axis, and times on Y. Maybe a bar chart with a bar for each swimmer on each date? Whenever I try to make such a graph, however, I have no success.

Any suggestions?

Also, these are the times for one single event (such as 100m butterfly). Would it be best to have a separate graph for every event (there are about a dozen of them).

Thanks!!!

 

[Toadstool]

Select all cells, Insert Bar/Column and choose an option. Then try Select Data and Switch Row/Column.

Yes, I think a separate graph for each event would be best.