// 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:D6").setValue(new Object[][]{ {null, "S1", "S2", "S3"}, {"Item1", 10, 25, 25}, {"Item2", -51, -36, 27}, {"Item3", 52, -85, -30}, {"Item4", 22, 65, 65}, {"Item5", 23, 69, 69} }); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:D6"), RowCol.Columns, true, true); IAxis value_axis = shape.getChart().getAxes().item(AxisType.Value); value_axis.setDisplayUnit(DisplayUnit.Custom); value_axis.setDisplayUnitCustom(100); value_axis.setHasDisplayUnitLabel(true); value_axis.getDisplayUnitLabel().getFont().getColor().setRGB(Color.GetCornflowerBlue()); value_axis.getDisplayUnitLabel().getFormat().getFill().getColor().setRGB(Color.GetOrange()); value_axis.getDisplayUnitLabel().getFormat().getLine().getColor().setRGB(Color.GetCornflowerBlue()); // Save to an excel file workbook.save("ConfigDisplayUnitLabel.xlsx");