Creating a waterfall chart

You can create a waterfall chart on the sheet you are editing.

Do the following:

1. From the assets panel, drag an empty waterfall chart to the sheet.

2. Add the first measure.

   This is the first bar of the chart. By default, it will use the measure operation Add, and show a positive value.

3. Add a second measure.

   This is the second bar of the chart. If you want to show this measure as a negative contribution, change Measure operation to Subtract.

4. Continue to add measures, setting Measure operation to Add or Subtract depending on how you want them to contribute.

5. Add subtotals. There are two ways of adding subtotal bars to the chart:

   • If you have a data field containing subtotal data, add a measure with the subtotal data and select Subtotals as Measure operation.
   • If you don't have a data field containing subtotal data, you can add an automatically calculated subtotal by selecting the Subtotals check box of the measure before where you want the subtotal bar.

You can add measures to the chart in different ways:

When you have created the waterfall chart, you may want to adjust its appearance and other settings in the properties panel.