So finally, I got the solution for you. It works, but it works only for your special set of data. The clue is that you have to calculate your "stacked" values by yourself and draw a normal area chart (no stacked area chart).

Column A are your dates, Column B to D your original values of the three divisions.
Column E is the sum of all three divisions =B2+C2+D2.
Column F is the difference between the negative division and the first division =B2+D2.

Now you draw a normal area chart with columns A and D to F. Then you sort the data rows so you see all areas:

1. DivC (column D)
2. Sum (column E)
3. DivA+DivC (column F)

and get the "simulated stacked" area chart you want and which has the correct values. Finally rename the headings of the columns according to your needs. Note that the order of the data rows in the legend is not straight A - B - C as the different areas would be hidden. But eventually you can change the data order and the formulas to get an appropriate sequence.

So finally, I got the solution. It works, but it works only for your special set of data. The clue is that you have to calculate your "stacked" values by yourself and draw a normal area chart (no stacked area chart).

Column A are your dates, Column B to D your original values of the three divisions.
Column E is the sum of all three divisions =B2+C2+D2.
Column F is the difference between the negative division and the first division =B2+D2.

Now you draw a normal area chart with columns A and D to F. Then you sort the data rows so you see all areas:

1. DivC (column D)
2. Sum (column E)
3. DivA+DivC (column F)

and get the "simulated stacked" area chart you want and which has the correct values. Finally rename the headings of the columns according to your needs. Note that the order of the data rows in the legend is not straight A - B - C as the different areas would be hidden. But eventually you can change the data order and the formulas to get an appropriate sequence.