Hi,

In order to start task2 where task1 ends you need to sum the values in
Task1.

Assuming Task1 information is in cells B4:D4 then the start date of Task2 in
cell B5 would be

=B4+C4+D4

And for more information on gantt charts see,
http://pubs.logicalexpressions.com/P...cle.asp?ID=343
http://peltiertech.com/Excel/Charts/GanttChart.html
http://peltiertech.com/Excel/Charts/GanttLinks.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"theredspecial" wrote in message
...
Dear all,

I've been able to produce a Gantt chart, sort of like I want it to be by
using this macro: http://support.microsoft.com/kb/213447. However I need
to
do some tweaking:

I want task 2 to start where task 1 ended, etc. Somehow I'm not able to
figure it out

Thnx!
The Red Special