I'd like to include negative values in stacked bar charts, with the total
stacked value equal to the sum of each of the subtotals. However, when I
tested this, it appears that Excel just shows the negative components at the
bottom of the bar, below zero, but the stacked total still seems to reflect
the sum of the positive components.

Is there a way of showing a stacked bar the way I'm trying to do it?

Todd