Waterfall Charts In Excel. Click insert insert waterfall or stock chart waterfall. The easiest way to assemble a waterfall chart in excel is to use a premade template.
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. Create waterfall chart in excel 2013 and earlier versions. Start with selecting your data in excel.
Waterfall chart visualizes a journey from a start point to the end point by going through ups and downs.
Activate the insert tab in the ribbon and click on the waterfall chart icon to see the chart types under category. Transform the column graph into a waterfall chart click on the base series to select them right click and choose the format data series option from the context menu. Create waterfall chart in excel 2013 and earlier versions. A waterfall chart is used for showing the overall effect by introducing positive or negatives steps.
