Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

farqueue

macrumors 6502
Original poster
Jun 18, 2006
456
32
Hi guys, i have problem making a line graph with excel::confused:

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.
 
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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.