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

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.

主站蜘蛛池模板: 崇礼县| 商洛市| 盐边县| 阜康市| 普格县| 奉节县| 治县。| 济阳县| 道真| 子洲县| 海盐县| 都安| 湖南省| 赤峰市| 苍山县| 德令哈市| 禄丰县| 焦作市| 永靖县| 柏乡县| 永州市| 普格县| 修文县| 七台河市| 阿坝县| 天全县| 陆良县| 寻乌县| 大洼县| 静海县| 辽源市| 定边县| 丹寨县| 托里县| 桐城市| 长治市| 清原| 马边| 长沙县| 广宁县| 鹿邑县|