Creating a (Gantt) sleep chart

Driz79

New Member
Joined
Feb 15, 2016
Messages
3
OK, after browsing the web for a few days, I can’t figure out how to create this specific Gantt sleep chart. It has with 6 daily repeated tasks (in this case sleep sessions), with data spread past midnight, from 18h00 until 06h00. The closest online instruction I found, was this one, but it doesn’t work for me: How to Make a Gantt Chart for Repeated Tasks | Katherine S. Rowell

It should look like this (created manually): https://app.box.com/s/5srre19xuiryyx33v5ku0871s00b13ou

The closest I got was this: https://app.box.com/s/z2rbjxjxcssrltnj767qvpy8z1pmitq2

Data set: https://app.box.com/s/2smnmuf6k5qkr7zadxitnqdqgxshuckg

So I need to:

  • fix the horizontal axis
  • differentiate the different kinds of tasks.

I would think this kind of chart would be easy to find, as I’m probably not the first person in the world to log my sleeping patern. But I can’t find this kind of chart anywhere. So I guess many people would benefit from this.

Any suggestions? Many thanks in advance!

D.
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

easy2understandexcel

Active Member
Joined
Dec 26, 2012
Messages
299
Looking at your data set; when you have two sleep rows back to back (for example 3rd and 4th row in the data set), but there is a time gap between them, do you assume the time between them was also sleep?
 

Driz79

New Member
Joined
Feb 15, 2016
Messages
3
Hi Easy2, thanks for looking into this!

No, this gap is regarded as 'up at night'-time. This is not always explicitly indicated as it is not the most important parameter (but relevant nonetheless).

FYI, the definitions used in sleep analysis are the following:

SOL = Sleep Onset Latency (when you get in bed, but are not yet asleep)
WASO = Wake After Sleep Onset (when you wake up at night and lie in bed awake)
EMA = Early Morning Awakening (lying in bed after waking up in the morning)
Sleep= Sleep

To make additional calculations:
TST = Total Sleep Time (all hours of sleep)
TIB = Time In Bed (SOL+WASO+EMA+TST)
SE = Sleep Efficiency (TST/TIB x 100)

With these, you can analyse your sleep patern and see which part is the most difficult.


Any suggestions on 'merging' the x-axis to a single 18h00 to 18h00 window? There's a clue in these instructions, but I can't make it work for me: How to Make a Gantt Chart for Repeated Tasks | Katherine S. Rowell

k r,
D.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,533
Messages
5,445,042
Members
405,307
Latest member
TINA31415

This Week's Hot Topics

Top