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:

C4=A5-A4 and D4=B4, D5=B5-B4

   2.   Select the data range (in this example A4:B10).

   3.   Click the Chart Wizard button (or choose Insert -> Chart...).

   4.   In the Chart Wizard dialog box, choose a XY (Scatter) type and the Scatter sub-type and then click Next >:

   5.   In the Step 2 of Chart Wizard, check the data and click Next >.

   6.   In the Step 3 of Chart Wizard:

• Remove Major gridlines on the Gridlines tab
• Remove the legend on the Legend tab.
  

   7.   In the Step 4 of Chart Wizard, click the Finish button.

   8.   In the popup menu choose Format Data Series....

In the Format Data Series dialog box:

• On the X Error Bars tab:
  • In the Display group, select Plus
  • In the Error Amount group, select Custom: and in the + section select data range (in this example C4:C10).
  
• On the Y Error Bars tab (see Adding error bars for more details about Error bars):
  • In the Display group, select Minus
  • In the Error Amount group, select Custom: and in the - section select data range (in this example D4:D10).
  

   6.   Right-click in one of the vertical Error bars and choose Format Y Error Bars... in the popup menu:

In the Format Error Bars dialog box, formal Y Error bars.

You can then make any other adjustments to get the look you desire.