Waterfall chart using Error bars
To create the waterfall chart using Error bars, do the following:
1. Add two columns with "X Errors" data and "Y Errors" data:
D5=B6-B5 and E5=C5, E6=C6-C5
2. Select the data range (in this example B5:C11).
3. On the Insert tab, in the Charts group, choose the Scatter button:
Choose simple Scatter.
4. On the Design tab, in the Chart Layouts group, click the Add Chart Element icon, select Error Bars list and then choose Series 1 X Error Bars:
5. In the Format Error Bars task pane:
- In the Direction group, select Minus
- In the End Style group, select No Cap
- In the Error Amount group, near the Custom click the Specify Value button.
In the Custom Error Bars dialog box, choose the Y Errors data range (in this example E5:E11). See Adding error bars for more details about Error bars.
6. On the Format Error Bars task pane, right-click in one of the Error Bar Options and choose Format Error Bars... in the popup menu:
In this Format Error Bars task pane:
- In the Display Direction group, select Minus
- In the Display End Style group, select No Cap
- In the Error Amount group, near the Custom, click the Specify Value button and then, in the Custom Error Bars dialog box, choose the X Errors data range (in this example D5:D10).
You can then make any other adjustments to get the look you desire.