官术网_书友最值得收藏!

  • .NET 4.0 Generics
  • David Lai Xavier Hacking
  • 206字
  • 2021-04-02 19:30:13

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...

  1. Drag a XY Chart component into the canvas.
  2. Bind the data By Range to spreadsheet cells B5 until C9.
  3. Bind the Chart field to cell A1 and delete the subtitle.
  4. 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.
  5. 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.

主站蜘蛛池模板: 久治县| 杭锦后旗| 马山县| 潍坊市| 松原市| 五家渠市| 行唐县| 黄大仙区| 安丘市| 高雄县| 威远县| 新郑市| 南京市| 陵川县| 读书| 新乐市| 台中县| 枣庄市| 伊春市| 盐边县| 区。| 奉节县| 元朗区| 杭锦后旗| 南京市| 鄢陵县| 博野县| 四会市| 伊宁县| 松滋市| 昭苏县| 手机| 晋州市| 民乐县| 临猗县| 都昌县| 巴南区| 纳雍县| 长沙县| 沁水县| 翼城县|