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

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...
主站蜘蛛池模板: 黎川县| 翁源县| 梓潼县| 广宁县| 印江| 南漳县| 河间市| 长汀县| 前郭尔| 交城县| 锦州市| 章丘市| 兴宁市| 淮阳县| 宁国市| 新巴尔虎左旗| 丁青县| 宝鸡市| 永寿县| 若尔盖县| 政和县| 维西| 来安县| 双桥区| 仁怀市| 霸州市| 勃利县| 嘉鱼县| 武胜县| 哈密市| 长海县| 金湖县| 洱源县| 滁州市| 调兵山市| 敦化市| 盐池县| 二连浩特市| 栾城县| 建昌县| 桐梓县|