Range chartRange; Object misValue = System.Reflection.Missing.Value; ChartObjects xlCharts = (ChartObjects)sheet0.ChartObjects(Type.Missing); ChartObject myChart = (ChartObject)xlCharts.Add(10, 70, 250, 250); Chart chartPage = myChart.Chart; chartRange = sheet0.get_Range("AN1", "AP6"); chartPage.SetSourceData(chartRange, misValue); chartPage.ChartType = XlChartType.xlColumnClustered;
Worksheet sheet2 = workbook.Worksheets[1];
chartPage.Location(XlChartLocation.xlLocationAsNewSheet, "Chart Name");
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)