上QQ阅读APP看书，第一时间看更新
Using the XY chart
An XY chart, or scatterplot, can display values that consist of two variables. The chart shows a set of points that, for each point, refer to a combination of a value on the X-axis and a value on the Y-axis.
Getting ready
Open a new Dashboard Design file and enter the data into the spreadsheet, as shown in the following screenshot:
How to do it...
- Drag a XY 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 is of each axis.
- Go to the Behavior tab and select the sub-tab Scale. Now select Fixed Label Size.
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, the houses priced between cheap and expensive (midclass) take a very long time to sell, while the expensive houses are somewhat in between.