[]
        
(Showing Draft Content)

瀑布图

瀑布图显示了添加或删除的值的集合减去。这个图表类型有助于理解初始值是如何受到一系列正的和负的影响的价值观。瀑布图表可用于查看产品收益、净收入或利润分析的波动。


用例代码

请参考以下代码以添加瀑布图。

private static void WaterfallChart() {
    // Initialize workbook
    Workbook workbook = new Workbook();
    // Fetch default worksheet
    IWorksheet worksheet = workbook.getWorksheets().get(0);

    // Prepare data for chart
    worksheet.getRange("A1:B8")
            .setValue(new Object[][] { 
                { "Starting Amt", 130 }, 
                { "Measurement 1", 25 }, 
                { "Measurement 2", -75 },
                { "Subtotal", 80 }, 
                { "Measurement 3", 45 }, 
                { "Measurement 4", -65 }, 
                { "Measurement 5", 80 },
                { "Total", 140 } });
    worksheet.getRange("A:A").getColumns().autoFit();

    // Add Waterfall Chart
    IShape waterfallChartShape = worksheet.getShapes().addChart(ChartType.Waterfall, 300, 20, 300, 250);
    waterfallChartShape.getChart().getSeriesCollection().add(worksheet.getRange("A1:B8"));

    // Configure Chart Title
    waterfallChartShape.getChart().getChartTitle().setText("Waterfall Chart");

    // Set subtotal & total points
    IPoints points = waterfallChartShape.getChart().getSeriesCollection().get(0).getPoints();
    points.get(3).setIsTotal(true);
    points.get(7).setIsTotal(true);

    // Connector lines are not shown
    ISeries series = waterfallChartShape.getChart().getSeriesCollection().get(0);
    series.setShowConnectorLines(false);

    // Saving workbook to Xlsx
    workbook.save("30-WaterfallChart.xlsx", SaveFileFormat.Xlsx);