HELP ........ Microsoft Excel

[farqueue]

Hi guys, i have problem making a line graph with excel:

I am trying to make this:
Y Axis - Time of the day (all 24 hours starting from 12am)
X Axis - Dates
2 line graphs with Sleep time and Wakeup time on it

I have the Data here but dont know how to do so, perhaps someone can help me and send me a copy of the spreadsheet captainkok@gmail.com

I just havent done this in ages and i forgotten how to do it.

Date Sleep Time Wakeup time
28-Aug 12:30 a.m. 7:30 a.m.
29-Aug 1:00 a.m. 8:30 a.m.
30-Aug 12:45 a.m. 9:30 a.m.
31-Aug 1:00 a.m. 10:30 a.m.
1-Sep 12:45 a.m. 11:30 a.m.

 

[iSaint]

I'm lost.

You can calculate total sleep time and graph that.

Maybe someone else here can figure it out.

 

[Am3822]

What you should do is to put your data into three cols. -- the first would hold the date (and serve as the x-axis data and labels), the second and third would hold the wake-up and sleep times, respectively.

You could then use the excel graphing wizard (if that's the way it's called) to generate the plot you're after. Once you've done that, you could fiddle with the y-axis range so that it would be from 12:00am and not from the minimal datapoint in your set.