Sharepoint Waterfall Table

I am using Excel in a Sharepoint file and am adding a Waterfall chart, however having trouble setting the final column as a total.  I can do it to the exact same data in a "non Sharepoint" Excel file. 

How do I set a total in a Sharepoint Excel Waterfall chart?