How do I add totals to a Stacked AREA graph in Excel? I want the value totals to be displayed @ top of area?

Answer 1

Create a 3rd column which is the sum of all the preceeding column.

Make a combo stacked, line chart

Change the iine chart to line color = none, only values are to be seen

You need to play with the chart a bit, Excel charts are highly flexible tools.

Answer 2

below is a VBA module which will do what you pick. First call cellular C1 "archives" and contact cellular D1 "CumTotal" do not placed any formulation in cellular D1. Now press Alt-F11 to boost the seen basic window. interior the undertaking-VBA undertaking window, double-click on the sheet call on your worksheet (not the call of the workbook, the call of the sheet). Then replica and paste the code below. the 1st line of the pasted code would be pink. replace "ByVa..." to "ByVal" and it is going to alter to black. on each and every occasion C1 adjustments, the macro is quickly performed. It provides the fee in C1 to the previous fee in D1 and gadgets D1 to the recent finished. given which you have named the cells, you ought to use cells different than C1 and D1 for the enter values and cumulative finished. inner maximum Sub Worksheet_SelectionChange(ByVal objective As Excel.selection) Dim DataCell As selection Set DataCell = selection("archives") If objective = DataCell Then selection("CumTotal").fee = selection("CumTotal").fee + selection("archives").fee end If end Sub you are able to e mail me via Yahoo!solutions in case you have any questions.