Creating waterfall charts in a simple way: positive values build-up the waterfall, negative build down. Create a subtotal by simply inserting a specific letter into a cell.

To make adapting the waterfall easier you should be able to reattach the connector to a different point and the waterfall rebuilds automatically and the underlying data is changed to without having to do anything.