How To Use Excel Waterfall Chart

Bars with no zero base are hard to interpret.

How to use excel waterfall chart. Use the fill tool to drag the formula down to the bottom of the column again. And boom your waterfall chart should now look like this. Now we need to convert this stack chart to waterfall chart with the below steps. If you want to see how i created these in excel you can download the excel file for these waterfall charts here. Select b4 in the chart and enter this formula.

It will give you three series. Navigate to the insert tab and click the waterfall chart button it s the one with the bars going both above and below the horizontal axis and then the waterfall chart type. Create helper columns for the original data. Now your excel waterfall chart should look like this. At this point you will see the first two but not the total.

Create waterfall chart in excel 2013 and earlier versions. You will get the chart as below. To use the new excel 2016 waterfall chart highlight the data area including the empty cell right above the categories and insert waterfall chart. Click on the color dropdown to select a color. Create the waterfall chart.

How to create a waterfall chart in excel 2016. You can also use the all charts tab in recommended charts to create a waterfall chart. Once the format data series pane appears to the right of your worksheet select the fill line icon. Use the design and format tabs to customize the look of your chart. Now for example you want to visualize the data on a waterfall chart.

This is another way to create them in excel. You can select the cells a3 b14 and click on chart type and select the waterfall chart. Now select the entire data range go to insert charts column under column chart select stacked column as shown in the below screenshot. Hence its useful to label the bars directly in a waterfall chart. On the excel ribbon click the insert tab and click column chart then click stacked column.