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:
How to do it...
Drag a Waterfall Chart component into the canvas.
Bind the Values field to the spreadsheet range from B3 to M3.
Bind the Labels field to the spreadsheet range from B1 to M1.
How it works...
Instead of showing the total value for...