Creating a (Gantt) sleep chart

**Driz79** · 02-15-2016, 11:09 AM

OK, after browsing the web for a few days, I can’t figure out how to create this specific Gantt sleep chart. It has 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: http://ksrowell.com/blog-visualizing...epeated-tasks/

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.

**Kaper** · 02-16-2016, 04:18 AM

Attach a sample workbook. not a screenshot - it's almost useless. And attach - not store on external server and provide link.
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**Driz79** · 02-16-2016, 06:39 PM

OK, I've bundled the 3 files in 1 workbook, see attached.

So now I'm compliant with forum regulations, any chance you could help me out on fixing the 24 hour X-axis and differentiating the tasks?

As said, there are many similar charts, but not identical. Can't make it work the way I need it to.

Many thanks!

D.