//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IShape shape = worksheet.getShapes().addChart(ChartType.XYScatter, 350, 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("A1:B7"), RowCol.Columns); shape.getChart().getSeriesCollection().add(worksheet.getRange("C1:D7"), RowCol.Columns); shape.getChart().getChartTitle().setText("Scatter Chart"); //config markers style ISeries series1 = shape.getChart().getSeriesCollection().get(0); ISeries series2 = shape.getChart().getSeriesCollection().get(1); series1.setMarkerStyle(MarkerStyle.Square); series1.setMarkerSize(10); series2.setMarkerSize(10); //save to an excel file workbook.save("XYScatterChart.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val shape = worksheet.shapes.addChart(ChartType.XYScatter, 350.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("A1:B7"), RowCol.Columns) shape.chart.seriesCollection.add(worksheet.getRange("C1:D7"), RowCol.Columns) shape.chart.chartTitle.text = "Scatter Chart" //config markers style val series1 = shape.chart.seriesCollection.get(0) val series2 = shape.chart.seriesCollection.get(1) series1.markerStyle = MarkerStyle.Square series1.markerSize = 10 series2.markerSize = 10 //save to an excel file workbook.save("XYScatterChart.xlsx")