Waterfall Chart Excel 2016. It s one of the most common charts for which people use additional third party add ins for. 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. You can also use the all charts tab in recommended charts to. In 2013 or earlier versions of excel the waterfall chart type is not present.
Create a data table.
Click on the fill line icon. Net sales gross margin operating income income before taxes and. If you want to build a waterfall chart of your own we ve got the step by step instructions for you. Create waterfall chart in excel 2016 and later versions in excel 2016 and later versions a new built in waterfall chart has been introduced.
