[]
瀑布图显示了添加或删除的值的集合减去。这个图表类型有助于理解初始值是如何受到一系列正的和负的影响的价值观。瀑布图表可用于查看产品收益、净收入或利润分析的波动。
请参考以下代码以添加瀑布图。
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);