Wasserfall Chart Excel. How to build an excel bridge chart step 1. On the left hand menu select waterfall near the bottom.
Convert the stacked chart into a waterfall chart click the base series right click then select format data series click fill in the menu and no fill in the drop down menu for colors. Steps to create a waterfall chart. The first step is to reorganize the data and introduce new columns as shown in the figure.
I have created peltier tech charts for excel to create waterfall charts and many other custom charts automatically from raw data.
Waterfall chart in excel is a quite a different but very useful tool that is used for showing the up and down in the data where each tower or column starts from the top of the lowest point of previous data. Alternatively you can work on a deck you ve already started but add a new slide where the waterfall chart will go. Repeat the same steps for the line section. Waterfall chart in excel is also known as bridge chart in excel which is a special type of column chart which is used to show how the start position of a certain data series changes over time be it a growth or decrease the first column in the waterfall chart is the first value while the last column in the waterfall chart is the final value and in total they represent the total value.
