ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   timeline/gantt chart (https://www.excelbanter.com/charts-charting-excel/225235-timeline-gantt-chart.html)

Laoballer

timeline/gantt chart
 
I have data that's in this format

ID CREATION_TIME ARRIVED_TIME STOP_TIME
236286 12/18/2008 18:22 12/18/2008 19:02 12/18/2008 21:00
236294 12/18/2008 21:00 12/18/2008 22:45 12/19/2008 4:08

with this data I need to create a timeline/gantt type chart. with the
y-axis being the different ID number and the X-axis being time. I'm
thinking it would look like a stacked barchart with the creation_time
and arrive_time as one set of data and then the arrived_time and
stop_time being another set. Where each data set starts and end would
be the min and max of the x-axis. I've tried following some gantt
charting tutorials but I can't seem to get the charting correct.
Another problem I'm encountering is that the time duration of these
events could change, meaning the creation_time to arrived_time could
range from minutes to hours in duration or the duration from
arrived_time to stop_time could be minutes, hours, or days in
duration.

Thanks,


All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com