Stacked area with more than one serie of negative values

**Jabj** · 06-03-2013, 06:43 AM

Hi,

I've problem finding an solution how to stack series when I've more than one series with negative values - when only one serie obtains negative values one could replace it to be the first serie and then the problem is solved.

But do any of you know how to operate with two or three series with negative values ?

In the attached workbook I've tried to illustrate my problem - the graph fails to incorporate the negative value in serie C and the sum don't add up with the attached series.

Thanks!

**Jabj** · 06-07-2013, 05:15 AM

Anyone who can fix this problem `?

**Andy Pope** · 06-07-2013, 08:27 AM

The chart is working as expected with the data provided. See how the last category of data points is constructed.

It's unclear what you expect the chart to look like