Categories

Waterfall Chart Generator

Create waterfall charts to visualize cumulative changes with positive/negative value distinction and subtotal display

Data items as JSON array with label, value, and optional isSubtotal flag

Title that will be displayed above the waterfall chart

Label for the X-axis

Label for the Y-axis

Color for positive value bars

Color for negative value bars

Color for subtotal and total bars

Color for connecting lines between bars

Width of each bar in pixels

Display values on top of bars

Automatically add final total bar

Display connecting lines between bars

Font size for labels and values

Font size for the chart title

Font family for text elements

Width of the chart in pixels

Height of the chart in pixels

Background color of the chart

Color of grid lines

Animate the chart when it loads

Animation duration in milliseconds

Key Facts

Category
Data Visualization
Input Types
text, textarea, color, number, checkbox, select
Output Type
html
Sample Coverage
4
API Ready
Yes

Overview

The Waterfall Chart Generator allows you to visualize cumulative changes in data, making it easy to track how positive and negative values contribute to a final total through a clear, step-by-step bridge chart.

When to Use

  • When you need to explain how an initial value increases or decreases to reach a final result.
  • When analyzing financial statements to show the breakdown of revenue, costs, and net profit.
  • When tracking inventory fluctuations or population changes over a specific period.

How It Works

  • Input your data as a JSON array, specifying labels, values, and whether an item is a subtotal.
  • Customize the visual appearance by adjusting colors for positive, negative, and total bars.
  • Configure chart dimensions, font styles, and value formats to match your reporting requirements.
  • Generate the chart to view the cumulative progression with optional connecting lines and auto-calculated totals.

Use Cases

Financial reporting to bridge the gap between starting budget and final expenditure.
Sales performance analysis showing how individual deals contribute to the monthly target.
Inventory management tracking stock levels through additions and shipments.

Examples

1. Monthly Profit Analysis

Financial Analyst
Background
The analyst needs to present a monthly profit report to stakeholders, showing how revenue and various expenses lead to the final net profit.
Problem
Standard bar charts do not clearly show the cumulative impact of expenses on the starting revenue.
How to Use
Input the revenue and expense items into the Data Items field, marking the starting revenue and final net profit as subtotals.
Example Config
[{"label": "Starting Revenue", "value": 5000, "isSubtotal": true}, {"label": "Sales", "value": 2000}, {"label": "Rent", "value": -1000}, {"label": "Salaries", "value": -1500}, {"label": "Net Profit", "value": 4500, "isSubtotal": true}]
Outcome
A clear waterfall chart showing the progression from 5000 to 4500, with expenses highlighted in red and revenue in blue.

Try with Samples

json, text

Related Hubs

FAQ

What is a waterfall chart?

A waterfall chart is a data visualization that shows how an initial value is affected by a series of intermediate positive or negative values to reach a final total.

How do I define subtotals in the data?

In your JSON input, add the 'isSubtotal': true flag to any data item that represents a calculated total rather than a change.

Can I change the colors of the bars?

Yes, you can independently set the colors for positive values, negative values, and subtotal bars using the color picker options.

Does the tool calculate the final total automatically?

Yes, if the 'Show Auto Total' option is enabled, the tool will automatically calculate and append the final total bar to your chart.

What formats are supported for values?

You can format values as integers, decimals (2 places), currency (¥), or percentages.

API Documentation

Request Endpoint

POST /en/api/tools/waterfall-chart-generator

Request Parameters

Parameter Name Type Required Description
chartTitle text No Title that will be displayed above the waterfall chart
dataItems textarea Yes Data items as JSON array with label, value, and optional isSubtotal flag
xAxisLabel text No Label for the X-axis
yAxisLabel text No Label for the Y-axis
positiveColor color No Color for positive value bars
negativeColor color No Color for negative value bars
totalColor color No Color for subtotal and total bars
connectingLineColor color No Color for connecting lines between bars
barWidth number No Width of each bar in pixels
showValues checkbox No Display values on top of bars
showTotal checkbox No Automatically add final total bar
showConnectingLines checkbox No Display connecting lines between bars
valueFormat select No -
fontSize number No Font size for labels and values
titleSize number No Font size for the chart title
fontFamily text No Font family for text elements
chartWidth number No Width of the chart in pixels
chartHeight number No Height of the chart in pixels
backgroundColor color No Background color of the chart
gridColor color No Color of grid lines
animationEnabled checkbox No Animate the chart when it loads
animationDuration number No Animation duration in milliseconds

Response Format

{
  "result": "
Processed HTML content
", "error": "Error message (optional)", "message": "Notification message (optional)", "metadata": { "key": "value" } }
HTML: HTML

AI MCP Documentation

Add this tool to your MCP server configuration:

{
  "mcpServers": {
    "elysiatools-waterfall-chart-generator": {
      "name": "waterfall-chart-generator",
      "description": "Create waterfall charts to visualize cumulative changes with positive/negative value distinction and subtotal display",
      "baseUrl": "https://elysiatools.com/mcp/sse?toolId=waterfall-chart-generator",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.

If you encounter any issues, please contact us at [email protected]