- SAP BusinessObjects Dashboards 4.1 Cookbook
- David Lai Xavier Hacking
- 275字
- 2021-07-23 19:44:04
Using a scatter plot chart
A scatter plot chart can display values that consist of two variables. The chart shows a set of points, each of which refer to a combination of a value on the x-axis and a value on the y-axis.
Getting ready
Open a new file in SAP BusinessObjects Dashboards and enter the data, as shown in the following screenshot, into the spreadsheet:
How to do it...
- Drag a Scatter Plot chart component into the canvas.
- Bind the data By Range to spreadsheet cells B5 until C9.
- Bind the Chart field to cell A1 and delete the subtitle.
- Bind the Value (X) Axis field to cell B4 and the Value (Y) Axis field to cell C4. Now it is clear what the implication of each axis is.
- Go to the Behavior tab and select the Scale sub-tab. Now select Fixed Label Size.
- Click on the Preview button to try the dashboard.
How it works...
In this example, we created a dashboard that compares the price of a house (variable 1) with the number of weeks until it is sold (variable 2). It shows us that cheap houses are sold very quickly; houses priced between cheap and expensive (mid-range) take a very long time to sell; while expensive houses are somewhat in between.
By using the Fixed Label Size option, the values of the x-axis are shortened for better readability. As we saw in the recipe, thousands (100,000) become K (100K). In addition, millions turn into M, billions into B, and trillions into T.