Getting ready

Open a new file in SAP BusinessObjects Dashboards and enter the data into the spreadsheet, as shown in the following screenshot:

How to do it...

How it works...

The bullet chart components can show a result value, a target, and qualitative ranges. Furthermore, each series can have its own label and sub-label. Let's have a look at exactly how these variables are configured in the preceding How to do it... section.

First, select By Series in the Data section of the properties pane for the Horizontal Bullet Chart component; then, select the Apple series. You can now see the detailed bindings SAP BusinessObjects Dashboards made for this series as shown in the following screenshot:

The Label field is bound to spreadsheet cell A5 (Apple). We did not edit the Sub-Label field so this remains empty, but you can bind it to a cell with a certain value or enter a value in this field directly. The result value, cell B5 (2200), is bound to the Performance Value field, which is represented in the chart by a small horizontal bar. Next, the target value of cell C5 (2000) is bound to the Comparative Value field. This value is visualized by a vertical dash. There are two cells that are bound as Scale Values: D5 (1800) and E5 (2400). Using two values means that the chart will show three areas: 0-1800, 1800-2400, and 2400-max. You can use as many values as you need. These areas are shown in the chart as three colored blocks in the background. If you don't use scale values, there won't be a colored block in the chart. Take a look at the following screenshot:

There's more...

The bullet chart in the recipe uses the same x-axis for all three series. It is also possible to configure separate x axes as done in the following steps: