// 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); // Set value type of first series' error bar as percentage series1.getYErrorBar().setValueType(ErrorBarType.Percentage); series1.getYErrorBar().setAmount(50); // Save to an excel file workbook.save("ConfigPercentageErrorBar.xlsx");