I am looking for ways to create a Gantt Chart for attached data:
1) On the X-axis, chart needs to have 0 to 24 hours; (24 buckets, each bucket representing an hour in a date)
2) On the Y-axis, chart needs (TaskDate, TaskUnit)
3) Chart should show stacked bars with each bar representing the start time of the task and task duration.
Goal of this chart is to give us a graphical representation of tasks by TaskDate, TaskUnit in the 24 hours of the date. This will tell us which task is starting when and which tasks are running in parallel etc.. based on task-starttime and task-duration.
Appreciate any help. Thanks.