Macro to produce Gantt Chart

[Amr Tabbarah]

I am trying to produce a Gantt Chart based on a set of Start Dates and
End Dates for Activities. I do not want the Gantt to be coloring cells
but drawing a rectangle with a certain color.

A manually produced sample Gantt Chart is attached to clarify my idea.

I would be interested in a macro that would read the cells containing
the time scale (Jan to Jul 2004 in cells E5 to K5), read the start and
end dates (cells C6 to D9) of the activities and produce the Gantt Bars
in a color to be selected by the user.

If this would make it easier, reading the start and end dates from the
current row and producing the Gantt Bar for the activitiy in that row
would be of great help.

Can anybody assist in finding a solution?

Thanks.


+----------------------------------------------------------------+
| Attachment filename: sample gantt chart.xls |
|Download attachment: http://www.excelforum.com/attachment.php?postid=344385|
+----------------------------------------------------------------+

 

[ryanb.]

go to:

http://come.to/TheGantTool

HTH

ryanb.

 

[Amr Tabbarah]

Thank you ryanb.

I will try the Gant Tool.


Amr

 

[Mike Witcombe]

Have a look at www.waa-inc.com/projex