// 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");