#1   Report Post  
Posted to microsoft.public.excel.charting
Baby's Sleep Log
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta
 
Posts: n/a
Default 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 , "?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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
baby charts sweetie40433 Excel Discussion (Misc queries) 1 September 10th 05 10:24 AM
Baby steps..... cpegram Excel Discussion (Misc queries) 5 June 4th 05 09:32 PM
Web Query Sleep for until results come Sunil_Modi Excel Worksheet Functions 0 November 19th 04 05:29 PM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"