Waterfall Chart Excel Multiple Series. However you can only have a single e segment per stack. Click insert insert waterfall or stock chart waterfall.
If you don t see these tabs click anywhere in the waterfall chart to add the chart tools to the ribbon. Right click and choose format data series from the list. Click on the base series to select them.
If you don t see these tabs click anywhere in the waterfall chart to add the chart tools to the ribbon.
First you should rearrange the data range insert three columns between the original two columns give them header names as base down and up. Right click and choose format data series from the list. If you use multiple e within a single stack then all segments except one will collapse and the remaining segment will stretch the entire extent. You can also use the all charts tab in recommended charts to create a waterfall chart.
