Add a Stock Chart
Add a Open High Low Close type stock chart.
Output: AddStockChart.xlsx
var workbook = new Workbook();
var worksheet = workbook.Worksheets[0];
worksheet.GetRange("J1:N1").SetValue(new[] { "Volume", "Open", "High", "Low", "Close" });
worksheet.GetRange("I2:I5").SetValue(new[] { "Point 1", "Point 2", "Point 3", "Point 4" });
worksheet.GetRange("J2:J5").SetValue(new[] { 1000, 1500, 500, 1000 });
worksheet.GetRange("K2:K5").SetValue(new[] { 9, 10, 11, 12 });
worksheet.GetRange("L2:L5").SetValue(new[] { 16, 14, 15, 13 });
worksheet.GetRange("M2:M5").SetValue(new[] { 3, 5, 4, 6 });
worksheet.GetRange("N2:N5").SetValue(new[] { 12, 11, 10, 9 });
var chart1 = worksheet.Charts.Add<StockChart>("A1");
chart1.StockChartType = StockChartType.OpenHighLowClose;
chart1.Size.HeightInches = 2.5;
chart1.Size.WidthInches = 3.5;
chart1.DataSource = "=Sheet1!$I$1:$I$5,Sheet1!$K$1:$N$5";
workbook.SaveAs("AddStockChart.xlsx");