HELP ........ Microsoft Excel

Discussion in 'Mac Apps and Mac App Store' started by farqueue, Sep 17, 2006.

  1. farqueue macrumors 6502

    farqueue

    Joined:
    Jun 18, 2006
    #1
    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.
     
  2. iSaint macrumors 603

    iSaint

    Joined:
    May 26, 2004
    Location:
    South Mississippi y'all, near the water!
    #2
    I'm lost.

    You can calculate total sleep time and graph that.

    Maybe someone else here can figure it out.
     
  3. Am3822 macrumors 6502

    Am3822

    Joined:
    Aug 16, 2006
    Location:
    Groningen, The Netherlands
    #3
    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.
     

Share This Page