Baby Sleep log

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top