help me in creating Gantt chart

**pradeepbm** · 08-07-2009, 02:37 AM

I am using this video tutorial to create a Gantt chart

http://www.youtube.com/watch?v=CW_wGSFavTc

My data is something like this

Task StartDateTime Cap Duration(Minutes)
task1 4/20/09 6:00 AM 4
task2 4/20/09 9:00 AM 20
task3 4/20/09 12:00 AM 8
task4 4/20/09 12:00 AM 1
task5 4/20/09 12:00 AM 46
task6 4/20/09 12:00 AM 10
task7 4/20/09 12:00 AM 0
task8 4/20/09 12:00 AM 0
task9 4/20/09 12:00 AM 2
task10 4/20/09 12:00 AM 2
task11 4/20/09 12:00 AM 9
task12 4/20/09 12:00 AM 1
task13 4/21/09 12:00 AM 1
task14 4/20/09 12:00 AM 21

I am facing problem once I set the min and max value for the horizontal axis as described in the tutorial. The horizontal bar graph are not displayed correctly. For e.g. Task1 starts correctly at 4/20/09 6 am but extends all the way to 4/23rd while duration is just 4 minutes. I think I have got something wrong while mapping the duration in minutes to horizontal axis.Can someone help. I have attached the graph as gif file.

**Andy Pope** · 08-07-2009, 04:45 AM

you need to convert you 4 to a true time value representing 4 mins.
In date/time format 4 represents 4 days.

Move your actual data to colulmn D and use this formula in column C

=D2/24/60

**pradeepbm** · 08-07-2009, 05:46 AM

Thanks a lot. Is it possible to write a formula D=Ci /24/60, where i=1,2,....

**Andy Pope** · 08-07-2009, 06:06 AM

just place the formula in a cell and the drag it down. The cell reference should automatically update.

**pradeepbm** · 08-07-2009, 06:22 AM

Thanks a lot Sir. Can you help me here http://www.excelforum.com/excel-char...ine-chart.html

What I need is to extend my current chart but there multiple columns of duration in minutes. This may be different for each tasks and that is where the challenge. Another question- Is it possible to alternate colors between duration blocks.