Way to add total amounts to stacked bar chart - without adding more data columns and line graphs

Hi All,

I have lots of graphs created which i need to now include the "Total" amounts for in graph. Given the large number of graphs, is there a way i can do this without going and creating a new column and summing the data. Then adding a line graphs component to my existing graphs?

Open to any suggestions including VBA.