Here is a little trick to create automatic totals on top of column charts. This is an alternative to placing text labels manually, and especially useful when the data in the column charts is changing frequently.