Automating Brackets, and Sum above Brackets in Excel Chart

Add another series as column, using formula to only display negative values. Make sure the series is on the Primary axis.
Set the Overlap to 100. Format as Red. This is the losses series.

Add 2 series to secondary axis and chart thier chart type to Line.
Use formula to display points for positive and negative values. Set the value to be used to be more than the max so the lines appear above the columns and data labels.