Horizontal Waterfall Chart Excel. In a waterfall chart the columns are distinguished by different colors so that you can quickly view positive and negative numbers. Start subtotals or totals from the horizontal axis.
Create waterfall chart in excel 2016 and later versions. Select data in cells a5 a19 then hold ctrl and select cells c5 e19 step 2. Insert tab line chart.
Show or hide connector lines.
Change chart type for subtotal and totals. Insert tab line chart. Create a waterfall chart create a waterfall chart. Select series 1 markers in the chart right click change series.
