//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); IShape shape = worksheet.getShapes().addChart(ChartType.LineMarkersStacked, 250, 20, 360, 230); worksheet.getRange("A1:C7").setValue(new Object[][]{ {0, 59.18, 27.14}, {44.64, 52.22, 25.08}, {45.21, 49.80, 57.99}, {24.32, 37.30, 42.73}, {58.34, 34.43, 28.34}, {31.89, 69.78, 46.88}, {41.79, 63.94, 56.24} }); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:C7"), RowCol.Columns); shape.getChart().getSeriesCollection().get(0).getFormat().getLine().setWeight(2.25); shape.getChart().getSeriesCollection().get(1).getFormat().getLine().setWeight(2.25); shape.getChart().getSeriesCollection().get(2).getFormat().getLine().setWeight(2.25); shape.getChart().getChartTitle().setText("Line Marker Stacked Chart"); //save to an excel file workbook.save("LineMarkerStackedChart.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val shape = worksheet.shapes.addChart(ChartType.LineMarkersStacked, 250.0, 20.0, 360.0, 230.0) worksheet.getRange("A1:C7").value = arrayOf(arrayOf(0, 59.18, 27.14), arrayOf(44.64, 52.22, 25.08), arrayOf(45.21, 49.80, 57.99), arrayOf(24.32, 37.30, 42.73), arrayOf(58.34, 34.43, 28.34), arrayOf(31.89, 69.78, 46.88), arrayOf(41.79, 63.94, 56.24)) shape.chart.seriesCollection.add(worksheet.getRange("A1:C7"), RowCol.Columns) shape.chart.seriesCollection.get(0).format.line.weight = 2.25 shape.chart.seriesCollection.get(1).format.line.weight = 2.25 shape.chart.seriesCollection.get(2).format.line.weight = 2.25 shape.chart.chartTitle.text = "Line Marker Stacked Chart" //save to an excel file workbook.save("LineMarkerStackedChart.xlsx")