well, here's catch: I'm not really using a Gantt Chart, I'm misusing it to
accumulate an effect in $ or ‚¬

The data looks like this:
start "duration" end
0 187 187
187 -200 -13
-13 -50 -63
-63 25 38
38 100 138
138 -62 76

which would hopefully result in a graph like this:
-----------------
-------------------
-----
-----
etc.


"Andy Pope" wrote:

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