Hi,
I'm trying to create a graph that compares several swimmers time at different meets. The data is stored as follows:
<tbody>
</tbody>
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!!!
I'm trying to create a graph that compares several swimmers time at different meets. The data is stored as follows:
Date | Swimmer A | Swimmer B | Swimmer C |
1/1/2018 | 01:53.55 | 01:50.51 | |
6/5/2018 | 01:34.22 | 01:45.12 | |
7/9/2018 | 01:30.10 | 01:35.12 |
<tbody>
</tbody>
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!!!