Gantt chart (stacked bar) with repeated tasks spanning midnight?

Driz79

New Member
Joined
Feb 15, 2016
Messages
3
Hi guys, I have some issues creating a gantt chart (stacked bar).

There's plenty of information about Gantt charts in general but not on these topics:

- repeating different daily tasks
- tasks that span midnight

So I'm stuck with the following:
-Creating horiz. axis from 18h to 18h (instead of 00:00 to 00:00)
-Crossing midnight (start one day and end the next)
-Continuing task from one row to the next
-Formatting the different tasks and creating the legend

Does it have something to do with making different data series per tasks? Maybe the data needs to be put in a pivot table? I can't seem to make this work :confused:

A sample of the data set and the chart I'm aiming for can be found here:
https://app.box.com/s/8topny8nycfo7gbpqenx18qyouh82s4r

Any suggestions would be greatly appreciated, I have a rather big data set to visualise here...
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,096,288
Messages
5,449,489
Members
405,566
Latest member
JeIIyfish

This Week's Hot Topics

Top