Forum Home
Press F1
Thread ID: 72558	2006-09-17 09:46:00	Calling all EXCEL genuises	d00zer (7983)	Press F1

Post ID	Timestamp	Content	User
485297	2006-09-17 09:46:00	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 out 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 . 2-Sep 12:00 a . m . 9:30 a . m . 3-Sep 1:30 a . m . 8:30 a . m . 4-Sep 1:00 a . m . 7:30 a . m . :confused: :confused: Thanks in advance	d00zer (7983)
485298	2006-09-17 11:51:00	Have a look at this: cdlaw.co.nz It helps to change time to 24hour clock e.g. "12:45 am" = "00:45" Otherwise copy that sample and see how source data and other options fit in. Cheers PS Sorry, got the labels reversed!	coldot (6847)
1