// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IShape shape = worksheet.getShapes().addChart(ChartType.XYScatter, 250, 20, 360, 230); worksheet.getRange("A1:D7").setValue(new Object[][]{ {"Blue", null, "Red", null}, {55, 964, 67, 475}, {20, 825, 10, 163}, {77, 840, 87, 224}, {182, 596, 46, 196}, {190, 384, 100, 377}, {140, 503, 92, 47}, }); shape.getChart().getSeriesCollection().add(worksheet.getRange("A2:B7"), RowCol.Columns); shape.getChart().getSeriesCollection().add(worksheet.getRange("C2:D7"), RowCol.Columns); shape.getChart().getChartTitle().setText("Scatter Chart"); // Get first series ISeries series1 = shape.getChart().getSeriesCollection().get(0); // Set HasErrorBars as true series1.setHasErrorBars(true); // Config y-direction error bar series1.getYErrorBar().setValueType(ErrorBarType.FixedValue); series1.getYErrorBar().setAmount(500); // Config x-direction error bar series1.getXErrorBar().setValueType(ErrorBarType.FixedValue); series1.getXErrorBar().setAmount(20); // Save to an excel file workbook.save("ConfigXYErrorBars.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val shape = worksheet.shapes.addChart(ChartType.XYScatter, 250.0, 20.0, 360.0, 230.0) worksheet.getRange("A1:D7").value = arrayOf(arrayOf("Blue", null, "Red", null), arrayOf(55, 964, 67, 475), arrayOf(20, 825, 10, 163), arrayOf(77, 840, 87, 224), arrayOf(182, 596, 46, 196), arrayOf(190, 384, 100, 377), arrayOf(140, 503, 92, 47)) shape.chart.seriesCollection.add(worksheet.getRange("A2:B7"), RowCol.Columns) shape.chart.seriesCollection.add(worksheet.getRange("C2:D7"), RowCol.Columns) shape.chart.chartTitle.text = "Scatter Chart" // Get first series val series1 = shape.chart.seriesCollection.get(0) // Set HasErrorBars as true series1.hasErrorBars = true // Config y-direction error bar series1.yErrorBar.valueType = ErrorBarType.FixedValue series1.yErrorBar.amount = 500.0 // Config x-direction error bar series1.xErrorBar.valueType = ErrorBarType.FixedValue series1.xErrorBar.amount = 20.0 // Save to an excel file workbook.save("ConfigXYErrorBars.xlsx")