Total series in clustered stacked column chart dynamically

This video shows a solution to quickly format total series in (side-by-side/clustered) stacked column charts for future updates.

Oftentimes the total values of stacked columns shall be shown in the chart as well. A common practice is to remove the fill color from the total segments and fixing the maximum value of the vertical y axis to use the entire area of the chart. While this practice works well for one set of data, it prevents the chart from adjusting to updated values.

1:44 - Pitfall of fixed y axis
2:43 - Dynamic solution by MSO-dlx
5:55 - Applied to clustered stacked columns