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

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

Using the bubble chart

A bubble chart can display values that consist of three variables. The only difference with the XY chart is that the size of the points in the bubble charts is adjustable. Next to the value on the X and Y-axes this is the third variable that can be illustrated with this chart.

Getting ready

You can reuse the dashboard from the Using the XY chart recipe and add the values in the D-column as shown in the following screenshot:

How to do it...

  1. Drag a Bubble Chart component into the canvas.
  2. Bind the data By Range to spreadsheet cells B5 through D9.
  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.
  5. Go to the Behavior tab and select the sub-tab Scale. Now select Fixed Label Size.

How it works...

In addition to the analysis we made in the Using the XY chart recipe, we can now also see that the number of houses for sale in the midclass market is very high, while the availability in the expensive market is very low.

主站蜘蛛池模板: 平泉县| 临澧县| 临泽县| 灵台县| 贡觉县| 班玛县| 顺平县| 翁牛特旗| 大同县| 甘孜| 女性| 含山县| 周宁县| 武汉市| 曲沃县| 卫辉市| 巴青县| 南安市| 桂东县| 玉环县| 青铜峡市| 田东县| 休宁县| 吉隆县| 保康县| 澄城县| 卢湾区| 大余县| 浠水县| 晋江市| 博爱县| 息烽县| 甘肃省| 普洱| 巴楚县| 青铜峡市| 瑞丽市| 剑河县| 会宁县| 清涧县| 宁蒗|