Documents for Excel, Java Edition Documentation
Features / Chart / Chart Types / Statistical Chart / Waterfall Chart
In This Topic
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();

IShape waterfallChartShape = worksheet.getShapes().addChart(ChartType.Waterfall, 300, 20, 300, 250);

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