Hi,
I need to create a stacked area chart with negative values. The chart should look exactly like the Excel chart in the attached screenshot. As long as Stacked area charts do not support negative values, I tried to create stacked series manually by adding values from previous series to the next.
I.e.

var stackedValues = new List();

// add the first area series
var areaSeries = (NAreaSeries)chart.Series.Add(SeriesType.Area);
areaSeries.FillStyle = new NColorFillStyle(Color.RoyalBlue);
var areaSeriesValues = new List { 10, 23, 12, 24, 16, 19, 17 };
stackedValues.AddRange(areaSeriesValues);
areaSeries.Values.AddRange(stackedValues);

// add the second area series
var areaSeries2 = (NAreaSeries)chart.Series.Add(SeriesType.Area);
areaSeries2.FillStyle = new NColorFillStyle(Color.DarkSalmon);
var areaSeries2Values = new List { -5, -13, -22, 15, 26, 11, -12 };

for (var i = 0; i < areaSeries2Values.Count; i++)
{
stackedValues[i] += areaSeries2Values[i];
}
areaSeries2.Values.AddRange(stackedValues);

But the first series overlaps the second, and the chart does not look like the Excel chart.
How can I make Nevron area chart with negative values look exactly like Excel stacked area chart? Or could I emulate Excel stacked area chart using another series type?

Thanks

Attachments

StackedAreaChart.png (341 views, 40.00 KB)