//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IShape shape = worksheet.getShapes().addChart(ChartType.ColumnClustered, 250, 20, 360, 230); worksheet.getRange("A1:D5").setValue(new Object[][]{ {null, "S1", "S2", "S3"}, {"Item1", 4, 25, 7}, {"Item2", 15, -10, 18}, {"Item3", 45, 90, 20}, {"Item4", 8, 20, 11} }); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:D5"), RowCol.Columns, true, true); IAxis value_axis = shape.getChart().getAxes().item(AxisType.Value); value_axis.setScaleType(ScaleType.Logarithmic); value_axis.setLogBase(5); //save to an excel file workbook.save("SetAxisScaleType.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val shape = worksheet.shapes.addChart(ChartType.ColumnClustered, 250.0, 20.0, 360.0, 230.0) worksheet.getRange("A1:D5").value = arrayOf(arrayOf(null, "S1", "S2", "S3"), arrayOf("Item1", 4, 25, 7), arrayOf("Item2", 15, -10, 18), arrayOf("Item3", 45, 90, 20), arrayOf("Item4", 8, 20, 11)) shape.chart.seriesCollection.add(worksheet.getRange("A1:D5"), RowCol.Columns, true, true) val value_axis = shape.chart.axes.item(AxisType.Value) value_axis.scaleType = ScaleType.Logarithmic value_axis.logBase = 5.0 //save to an excel file workbook.save("SetAxisScaleType.xlsx")