How do I create a waterfall chart step by step? How do I add sums, connecting lines or other properties to a waterfall chart? We will show you how to create, label, and edit a waterfall chart yourself via Excel or directly in PowerPoint. Check out our Microsoft 365 guide for more tips and tricks to help you work with Microsoft applications.
A classic waterfall chart is read from left to right. You see a so-called running total, whose values are added or subtracted. The categories on the horizontal x-axis usually represent a time period, such as months or quarters. This allows you to evaluate, for example, whether a month ended positively or negatively and what the current balance looks like.
Since Office 2016, a waterfall chart is included as a basic chart type in both Excel and PowerPoint. Check out our article on creating charts without dedicated software to find out about more chart types in Excel and PowerPoint. In this article, however, you will learn how to create a waterfall chart in addition to:
Do you want to insert data from an Excel spreadsheet into PowerPoint and display it as a waterfall chart? You just need to follow these 4 steps:
Learn how to edit a waterfall chart. We will show you how, using a diagram in PowerPoint, but in Excel, the editing steps work the same.
In the example chart, you see there are no subtotals. We show you how to set totals e.g. for each Quartal.
Do you want to represent a column as a sum of the previous values? So that it grows starting from the x-axis and does not flow? Then simply right-click on the column and select "Set as Total" from the list. The other way around, you can click on columns and right-click to select "Clear Total". This will automatically adjust your waterfall chart.
Double-click on any column in your waterfall chart so that the editing window appears on the right. Now you can check or uncheck the box "Show connector lines".
If your data is in the minus range, a negative range is automatically displayed on the Y-axis.
The columns are color-coded so you can distinguish the positive and negative numbers. However, if you are not satisfied with the preset colors of your waterfall chart, you can select a suitable color by double-clicking on a column.
Even easier is the global adjustment of colors. For example, all totals should be displayed in green. Double-click on the respective legend and select the appropriate color. Then all associated columns will be colored at once.
In order to control your brand, your charts should always match the colors, fonts, and features of your corporate design. With the empower® Chart Creation solution you can completely automate such tedious work. We show you how to comply with your corporate design in every presentation with just one click, in our article “Corporate Design Check with empower®”.
The Microsoft Office add-in empower® Chart Creation offers you more functionalities and types for waterfall charts directly in PowerPoint. The add-in simplifies the creation of design-compliant charts and saves you time.
For example, use the waterfall chart with stacked columns or create a waterfall chart in a landscape with bars.
You can insert breaks if the proportions of your displayed values are too different.
It is also possible to add growth arrows, value lines, or other visualizations to strengthen and simplify your chart.
You have a wide range of new possibilities to design your waterfall chart with just a few clicks. Our best practice video gives you an overview of the easy implementation.
With empower® Chart Creation you can create all your PowerPoint charts easily, consistently, and efficiently.
There are a variety of chart types, such as Gantt charts, Mekko charts, waterfall charts, area charts, etc. With the right representation, you can support the meaning of your data and communicate it successfully. Do you want to learn more about the most useful charts in PowerPoint?
Do you have further questions about empower® Chart Creation or perhaps about our empower® Brand Control solution? Please contact us!