Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Timeline Chart, but not a Gantt | Charts and Charting in Excel | |||
Timeline Chart | Charts and Charting in Excel | |||
Timeline Chart? | Excel Discussion (Misc queries) | |||
timeline chart | Excel Worksheet Functions | |||
Timeline Chart? | Charts and Charting in Excel |