// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A1:D16").setValue(new Object[][]{ {"Course", "SchoolA", "SchoolB", "SchoolC"}, {"English", 63, 53, 45}, {"Physics", 61, 55, 65}, {"English", 63, 50, 65}, {"Math", 62, 51, 64}, {"English", 46, 53, 66}, {"English", 58, 56, 67}, {"Math", 60, 51, 67}, {"Math", 62, 53, 66}, {"English", 63, 54, 64}, {"English", 63, 52, 67}, {"Physics", 60, 56, 64}, {"English", 60, 56, 67}, {"Math", 61, 56, 45}, {"Math", 63, 58, 64}, {"English", 59, 54, 65} }); //Create a box&whisker chart. IShape shape = worksheet.getShapes().addChart(ChartType.BoxWhisker, 300, 20, 300, 200); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:D16")); //Config value axis's scale. IAxis value_axis = shape.getChart().getAxes().item(AxisType.Value, AxisGroup.Primary); value_axis.setMinimumScale(40); value_axis.setMaximumScale(70); //Config the display of box&whisker plot. ISeries series = shape.getChart().getSeriesCollection().get(0); series.setShowInnerPoints(true); series.setShowOutlierPoints(false); series.setShowMeanMarkers(false); series.setShowMeanLine(true); series.setQuartileCalculationInclusiveMedian(true); // Save to an excel file workbook.save("AddBoxWhiskerChart.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) worksheet.getRange("A1:D16").setValue(arrayOf(arrayOf("Course", "SchoolA", "SchoolB", "SchoolC"), arrayOf("English", 63, 53, 45), arrayOf("Physics", 61, 55, 65), arrayOf("English", 63, 50, 65), arrayOf("Math", 62, 51, 64), arrayOf("English", 46, 53, 66), arrayOf("English", 58, 56, 67), arrayOf("Math", 60, 51, 67), arrayOf("Math", 62, 53, 66), arrayOf("English", 63, 54, 64), arrayOf("English", 63, 52, 67), arrayOf("Physics", 60, 56, 64), arrayOf("English", 60, 56, 67), arrayOf("Math", 61, 56, 45), arrayOf("Math", 63, 58, 64), arrayOf("English", 59, 54, 65))) //Create a box&whisker chart. val shape = worksheet.shapes.addChart(ChartType.BoxWhisker, 300.0, 20.0, 300.0, 200.0) shape.chart.seriesCollection.add(worksheet.getRange("A1:D16")) //Config value axis's scale. val value_axis = shape.chart.axes.item(AxisType.Value, AxisGroup.Primary) value_axis.minimumScale = 40.0 value_axis.maximumScale = 70.0 //Config the display of box&whisker plot. val series = shape.chart.seriesCollection.get(0) series.showInnerPoints = true series.showOutlierPoints = false series.showMeanMarkers = false series.showMeanLine = true series.quartileCalculationInclusiveMedian = true // Save to an excel file workbook.save("AddBoxWhiskerChart.xlsx")