Waterfall Chart Template

Waterfall Chart Template

This waterfall chart template guides you step-by-step to construct a waterfall chart using raw data.

Here is a screenshot of the waterfall chart template:

Download the Free Template

Enter your name and email in the form below and download the free template now!

Waterfall chart is a great way to visually show the effect of positive and negative cash flows on a cumulative basis. In Excel 2016, there is a built-in waterfall chart option so it is a very simple and quick process. If you’re working in Excel 2013 or earlier version, you will have to build your own waterfall chart using the stacked column chart feature.

Step 1 – Create a data table with 7 columns

In order to build your own waterfall chart, you first have to organize your data into a table.

Step 2 – Build the waterfall chart using Up/Down Bars

Use the Up/Down Bars feature in charts to create the foundation of the waterfall chart.

Step 3 – Add data labels to the bars and columns

Using the column Data label position to define the position of the data labels.

Step 4 – Insert connectors between each bar using Error Bars

Use Error Bars feature in charts to show changes between each Up/Down bar.

More Free Templates

For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation and Word document templates.

• Excel Modeling TemplatesExcel & Financial Model TemplatesDownload free financial model templates - CFI's spreadsheet library includes a 3 statement financial model template, DCF model, debt schedule, depreciation schedule, capital expenditures, interest, budgets, expenses, forecasting, charts, graphs, timetables, valuation, comparable company analysis, more Excel templates
• PowerPoint Presentation Templates
• Transaction Document TemplatesTransactionsDownload free transaction templates including a Letter of Intent (LOI), Term Sheet, Non-Disclosure Agreement (NDA), Confidential Information Memorandum (CIM), Equity Capital Markets (ECM) memo, Due Diligence checklist, and other types of corporate transactions. Download the Word Document files for your own use