How to create a chart with multi chart type.

Dec 16, 2015 at 5:18 AM
Edited Dec 16, 2015 at 5:43 AM
Good afternoon everyone, I want to create a chart include line(eChartType) and column(eChartType), how to use EPPlus to achieve ?

such as this following pic.
Image



Sorry, the answer as below:
        var chart = sheet.Drawings.AddChart("chart2", eChartType.ColumnStacked);
        chart.SetPosition(0, 540);
        chart.SetSize(800, 600);


        var chartType2 = chart.PlotArea.ChartTypes.Add(eChartType.LineStacked);
        chartType2.UseSecondaryAxis = true;
        var serie3 = chartType2.Series.Add(range.Offset(1, 2, range.End.Row - 1, 1), range.Offset(1, 0, range.End.Row - 1, 1));
        serie3.Header = "Items in stock";