You can take the numbers you want to plot and create a grid using the formulas as shown in the diagram. This takes the guesswork involved in the first step of knowing which cells to keep blank and which ones to populate. In this method, you will need to copy the 4 cells downwards to as many rows as there are data points to be plotted. The second method, and the one that I prefer is to create a 4 column layout with specific formulas in each. However I personally find it time consuming and error prone. The trick here lies in knowing which cells in the grid to keep blank and which ones to populate with numbers. The first is to simply lay out a grid of number and create a column chart based on it. There are two ways to create a waterfall chart in Excel. How do I create a waterfall chart in excel? If all you need to do is to get a copy of the Excel Waterfall Chart Template with Negative Values then you can simply download it here.įor those interested in knowing how to create a waterfall chart in excel, please read on.