//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IShape shape = worksheet.getShapes().addChart(ChartType.Bubble, 250, 20, 360, 230); worksheet.getRange("A1:C10").setValue(new Object[][]{ {"Blue", null, null}, {125, 750, 3}, {25, 625, 7}, {75, 875, 5}, {175, 625, 6}, {"Red", null, null}, {125, 500, 10}, {25, 250, 1}, {75, 125, 5}, {175, 250, 8}, }); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:C5"), RowCol.Columns); shape.getChart().getSeriesCollection().add(worksheet.getRange("A6:C10"), RowCol.Columns); shape.getChart().getChartTitle().setText("Bubble Chart"); //save to an excel file workbook.save("BubbleChart.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val shape = worksheet.shapes.addChart(ChartType.Bubble, 250.0, 20.0, 360.0, 230.0) worksheet.getRange("A1:C10").value = arrayOf(arrayOf("Blue", null, null), arrayOf(125, 750, 3), arrayOf(25, 625, 7), arrayOf(75, 875, 5), arrayOf(175, 625, 6), arrayOf("Red", null, null), arrayOf(125, 500, 10), arrayOf(25, 250, 1), arrayOf(75, 125, 5), arrayOf(175, 250, 8)) shape.chart.seriesCollection.add(worksheet.getRange("A1:C5"), RowCol.Columns) shape.chart.seriesCollection.add(worksheet.getRange("A6:C10"), RowCol.Columns) shape.chart.chartTitle.text = "Bubble Chart" //save to an excel file workbook.save("BubbleChart.xlsx")