Waterfall Chart | Document Solutions for Excel, Java Edition

Waterfall Chart

In This Topic

A waterfall chart shows the aggregate of values as they are added or subtracted.This type of chart is useful to understand how the initial value is affected by a series of positive and negative values.Waterfall charts can be used for viewing fluctuations in product earnings, net income or profit analysis.

Using Code

Refer the following code for adding Waterfall chart.

Java	Copy Code
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);

Java

Copy Code

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