Waterfall Chart Excel 2016. You just need to make the base series invisible to get a waterfall chart from a stacked column. Then find waterfall in the list of available.
Click insert insert waterfall or stock chart waterfall. Click on the base series to select them right click and choose the format data series option from the context menu. Then select waterfall in the menu.
The format data series pane immediately appears to the right of your worksheet in excel 2013 2016.
Although excel 2016 includes a waterfall chart type within the chart options if you re working with any version older than that you will need to construct the waterfall chart from scratch. The format data series pane immediately appears to the right of your worksheet in excel 2013 2016. Navigate to the insert tab and click the waterfall chart button it s the one with the bars going both above and. Although excel 2016 includes a waterfall chart type within the chart options if you re working with any version older than that you will need to construct the waterfall chart from scratch.
