Graphing swimmers' times over time

petersw

New Member
Joined
Sep 22, 2011
Messages
10
Hi,

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

DateSwimmer ASwimmer BSwimmer C
1/1/201801:53.5501:50.51
6/5/201801:34.2201:45.12
7/9/201801:30.1001: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!!!
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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.
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,194
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top