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
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...
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
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...
