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

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

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,126,965
Messages
5,621,865
Members
415,862
Latest member
nascaline

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top