Excel.Range chartRange1; Excel.ChartObjects xlCharts1 = (Excel.ChartObjects)worksheet.ChartObjects(Type.Missing); Excel.ChartObject myChart1 = (Excel.ChartObject)xlCharts1.Add(350, 500, 500, 350); Excel.Chart chartPage1 = myChart1.Chart; chartRange1 = worksheet.get_Range("A33", "b53"); chartPage1.SetSourceData(chartRange1, Type.Missing); chartPage1.ChartType = Excel.XlChartType.xlBarStacked; Excel.Range xValues = worksheet.Range["B33", "B53"]; Excel.Range values = worksheet.Range["a33", "a53"]; Excel.SeriesCollection seriesCollection = (Excel.SeriesCollection)chartPage1.SeriesCollection(); Excel.Series series1 = seriesCollection.NewSeries(); series1.XValues = xValues; series1.Values = values;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)