Waterfall Chart Excel Multiple Series. Use the design and format tabs to customize the look of your chart. Click on the base series to select them.
Create helper columns for the original data. 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. Click on the base series to select them.
If you have excel 2013 and earlier versions the excel does not support this waterfall chart feature for you to use directly in this case you should apply the below method step by step.
Create waterfall chart in excel 2013 and earlier versions. First you should rearrange the data range insert three columns between the original two columns give them header names as base down and up. Click on the base series to select them. Right click and choose format data series from the list.
