Showing customized intermediate total bars

The intermediate total bars in a waterfall chart usually summarize categories at certain levels in a hierarchically organized data. However, you can customize which categories an intermediate total bar should represent.

The example below illustrates how this can be done using grouping categories.

The waterfall chart shows sales figures for a number of countries. Assume you want to show one intermediate total for the Benelux countries (Belgium, Netherlands, and Luxembourg), and one intermediate total for the Nordic countries (Norway and Sweden), but still be able to view the contribution from each of these countries.

Procedure

  1. In the waterfall chart, mark the Belgium, Luxembourg, and Netherlands blocks.
  2. Right-click the waterfall chart, and select Group from marked categories.
    The Group from marked categories dialog opens, see below.
  3. In the drop-down list, select the column containing the values to group.
  4. Check that correct axis is selected, and correct values.
  5. Type a name of the new group, Benelux, and click OK.


  6. In the same way as described above, group Norway and Sweden into a Nordic value.
    A new data column, named Country (grouped) and containing the Benelux and Nordic values, is created.

  7. Using the new data column, create a hierarchy on the category axis as shown below.


  8. Right-click the waterfall chart, and in the opened Properties dialog, click Total bars.


  9. Select One total bar per value in, and make sure Country (grouped) is selected in the drop-down list.
    Intermediate total bars for Benelux and Nordic are shown.