// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IShape shape = worksheet.getShapes().addChart(ChartType.Line, 250, 20, 360, 230); worksheet.getRange("A1:D4").setValue(new Object[][]{ {null, "Q1", "Q2", "Q3"}, {"Mobile Phones", 1330, 2330, 3330}, {"Laptops", 4032, 5632, 6197}, {"Tablets", 6233, 7233, 8233} }); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:D4"), RowCol.Rows); // Get first series ISeries series1 = shape.getChart().getSeriesCollection().get(0); // Set HasErrorBars as true series1.setHasErrorBars(true); // Config first series' error bar series1.getYErrorBar().setType(ErrorBarInclude.Both); series1.getYErrorBar().setEndStyle(EndStyleCap.Cap); // Get third series ISeries series2 = shape.getChart().getSeriesCollection().get(2); // Set HasErrorBars as true series2.setHasErrorBars(true); // Config third series' error bar series2.getYErrorBar().setType(ErrorBarInclude.Plus); series2.getYErrorBar().setEndStyle(EndStyleCap.NoCap); // Save to an excel file workbook.save("ConfigErrorBarIncludeAndEndType.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val shape = worksheet.shapes.addChart(ChartType.Line, 250.0, 20.0, 360.0, 230.0) worksheet.getRange("A1:D4").value = arrayOf(arrayOf(null, "Q1", "Q2", "Q3"), arrayOf("Mobile Phones", 1330, 2330, 3330), arrayOf("Laptops", 4032, 5632, 6197), arrayOf("Tablets", 6233, 7233, 8233)) shape.chart.seriesCollection.add(worksheet.getRange("A1:D4"), RowCol.Rows) // Get first series val series1 = shape.chart.seriesCollection.get(0) // Set HasErrorBars as true series1.hasErrorBars = true // Config first series' error bar series1.yErrorBar.type = ErrorBarInclude.Both series1.yErrorBar.endStyle = EndStyleCap.Cap // Get third series val series2 = shape.chart.seriesCollection.get(2) // Set HasErrorBars as true series2.hasErrorBars = true // Config third series' error bar series2.yErrorBar.type = ErrorBarInclude.Plus series2.yErrorBar.endStyle = EndStyleCap.NoCap // Save to an excel file workbook.save("ConfigErrorBarIncludeAndEndType.xlsx")