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