官术网_书友最值得收藏!

Using a waterfall chart

A waterfall chart is useful to visualize the fluctuation of a value in positive and negative values. The first and final values are displayed as full columns (starting at 0). The values in between represent the positive and negative fluctuations. A good example is the stock level of goods in a warehouse. A waterfall chart can show how it changes over time.

This recipe shows you how to set up such a waterfall chart.

Getting ready

Open a new SAP BusinessObjects Dashboards file and enter data in the spreadsheet as shown in the following screenshot. As you can see in row 3, the first and final value (January and December) show the total stock level, instead of the change relative to the previous period, as is shown in the other months:

Getting ready

How to do it...

  1. Drag a Waterfall Chart component into the canvas.
  2. Bind the Values field to the spreadsheet range from B3 to M3.
  3. Bind the Labels field to the spreadsheet range from B1 to M1.
    How to do it...

How it works...

Instead of showing the total value for each category, the waterfall chart shows how an initial value (January) changes over time until it ends in the final value (December). To make this work, you have to make sure that the first and final values of your dataset represent the actual initial and final value. The other values that are in between should only represent the amount of increase or decrease of a value.

There's more...

There are four categories of values in a waterfall chart: initial value, final value, positive value, and negative value. These values all have their own color. Initially, the positive values are green and the negative ones are red. In the Series sub-tab within the Appearance tab of the properties pane, you can change the color of each type of value:

There's more...
主站蜘蛛池模板: 青铜峡市| 洪湖市| 远安县| 湄潭县| 屏东县| 平泉县| 牡丹江市| 辰溪县| 宜章县| 京山县| 沾化县| 昌图县| 镇巴县| 遂川县| 兴和县| 澄江县| 韶山市| 天台县| 措勤县| 五莲县| 辽源市| 姚安县| 闵行区| 金乡县| 隆尧县| 青阳县| 泾川县| 长汀县| 望江县| 永德县| 北宁市| 衡阳县| 盐津县| 临夏县| 大石桥市| 邵武市| 温宿县| 西畴县| 永德县| 彭山县| 民勤县|