A Gantt Chart with Costs

Dave Morrow

Is it possible to produce a Gantt Chart with costs?

ie as you add Parents & Children the Parents Costs row will total the Children Costs row

Have tried various formulae but other than building the full Schedule then adding formulae to each Parent row it seems to be a long winded method of populating the costs.

Can anybody help??

Travis

Dave, it sounds like you want parent rows to SUM child rows, correct? Try adding this formula to the parent row column where the child row values you want to SUM are located:

 

=SUM(CHILDREN()) 

 

This will sum all the child rows in the column where this formula is located. 

Dave Morrow

Travis

Ta very much. Works a treat!