Using a bullet chart
A bullet chart is in fact a bar or column chart with a lot of extra options. It can serve as a replacement for gauges and meters. Besides visualizing a data point as bar and column charts do, a bullet chart is able to show a target and two or more qualitative ranges. These ranges can indicate whether a value can be considered bad, satisfactory, good, and so on.
This recipe will show you how to configure a bullet chart. SAP BusinessObjects Dashboards has two bullet chart components: horizontal and vertical. Both components have exactly the same configuration options and work in the same manner. This recipe will use the horizontal bullet chart.
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...
- Drag a Horizontal Bullet Chart component into the canvas.
- Bind the By Range field to the spreadsheet range from A4 to E7:
- Also bind the Chart field in the Titles section to spreadsheet...
