// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A1:B7").setValue(new Object[][]{ {"Stage", "Amount"}, {"Prospects", 500}, {"Qualified prospects", 425}, {"Needs analysis", 200}, {"Price quotes", 150}, {"Negotiations", 100}, {"Closed sales", 90} }); worksheet.getRange("A:A").getColumns().autoFit(); //Create a funnel chart. IShape shape = worksheet.getShapes().addChart(ChartType.Funnel, 300, 20, 300, 200); shape.getChart().getSeriesCollection().add(worksheet.getRange("A1:B7")); //Set the axis invisible. IAxis axis = shape.getChart().getAxes().item(AxisType.Category, AxisGroup.Primary); axis.setVisible(false); // Save to an excel file workbook.save("AddFunnelChart.xlsx");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) worksheet.getRange("A1:B7").setValue(arrayOf(arrayOf("Stage", "Amount"), arrayOf("Prospects", 500), arrayOf("Qualified prospects", 425), arrayOf("Needs analysis", 200), arrayOf("Price quotes", 150), arrayOf("Negotiations", 100), arrayOf("Closed sales", 90))) worksheet.getRange("A:A").columns.autoFit() //Create a funnel chart. val shape = worksheet.shapes.addChart(ChartType.Funnel, 300.0, 20.0, 300.0, 200.0) shape.chart.seriesCollection.add(worksheet.getRange("A1:B7")) //Set the axis invisible. val axis = shape.chart.axes.item(AxisType.Category, AxisGroup.Primary) axis.visible = false // Save to an excel file workbook.save("AddFunnelChart.xlsx")