Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 19
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Timeline Chart, but not a Gantt Shelly Charts and Charting in Excel 0 June 26th 08 03:10 PM
Timeline Chart Urgent question regarding LIST[_2_] Charts and Charting in Excel 1 March 22nd 08 07:15 PM
Timeline Chart? PaulW Excel Discussion (Misc queries) 2 December 18th 07 06:25 AM
timeline chart jtaiariol Excel Worksheet Functions 0 June 20th 07 06:39 PM
Timeline Chart? ckrogers Charts and Charting in Excel 3 March 17th 05 09:20 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"