A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

timeline/gantt chart



 
 
Thread Tools Display Modes
  #1  
Old March 23rd, 2009, 03:53 PM posted to microsoft.public.excel.charting
Laoballer
external usenet poster
 
Posts: 51
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,
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:07 PM.


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