If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Baby Sleep log
I want to create a graph of my babies sleep,awake,feeding times, etc.
In a 24-hour day it's shown as a separate bar on the graph with the horizontal axis as the day of the week and the vertical axis the time of day. So what you see is a series of bar graphs. Each bar is color-coded for sleep times and wake times. Other times such as crying times, feedings. periods in crib awake, periods in crib asleep, or periods asleep in parent's arms may be included. Could someone please explain how I get this into excel of give me this graft? Thank you. |
#2
|
|||
|
|||
Baby Sleep log
You may want to consider a slightly different approach to this.
Suppose you have in row 1 the various categories of interest to you. So, B1 would have 'asleep', C2 would have 'awake' and so on. Now, in column 1 put in the times in, say 30 minute intervals (or if you prefer 15 minute intervals). So, A2 will have 2/2 00:00 A3 would have 2/2 00:30 etc. Now, in each cell where an event of interest is going on, put in a 1. Use conditional formatting to set the cell pattern to some color. To do that select columns B:C (or B:whatever you are using), then Format | Conditional Formatting... Change the 2nd drop down from Between to 'Equal to' and in the next field enter 1. Click the Format... button and from the Patterns tab select an approriate color. This treats the worksheet as a chart. You can add multiple conditions to any given time interval. For example, 'playing' or 'quiet' could be column headings as could be 'in crib' and 'in arms'. Now to indicate awake, playing, and 'in arms' just put a 1 in each appropriate cell. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , "=?Utf-8?B? QmFieSdzIFNsZWVwIExvZw==?=" Baby's Sleep says... I want to create a graph of my babies sleep,awake,feeding times, etc. In a 24-hour day it's shown as a separate bar on the graph with the horizontal axis as the day of the week and the vertical axis the time of day. So what you see is a series of bar graphs. Each bar is color-coded for sleep times and wake times. Other times such as crying times, feedings. periods in crib awake, periods in crib asleep, or periods asleep in parent's arms may be included. Could someone please explain how I get this into excel of give me this graft? Thank you. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Tracking daily Bipolar Meds, Moods, Activities, Sleep? | Shortwired | Database Design | 1 | December 9th, 2005 02:28 PM |
My presentation goes into sleep mode | jimdive353 | Powerpoint | 6 | October 12th, 2005 08:59 PM |
Using access with DB from a usb drive, and it went to sleep! | frixtine | General Discussion | 1 | October 5th, 2005 04:20 PM |
scrapbook for new baby | VickiA | Powerpoint | 1 | October 25th, 2004 12:00 AM |
Graph Question | Jason and Cindy MacKenzie | Charts and Charting | 1 | March 24th, 2004 10:12 PM |