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

Using a bubble plot chart

A bubble plot chart is essentially the same as a scatter plot chart, except that it has a third variable that determines the size of each point. The following screenshot represents a bubble plot chart:

Using a bubble plot chart

Getting ready

You can reuse the dashboard from the Using a scatter plot chart recipe and add the values in column D, as shown in the following screenshot:

Getting ready

How to do it...

  1. Drag a Bubble Plot 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 Scale sub-tab. Now select Fixed Label Size.

How it works...

In addition to the analysis we made in the Using a scatter plot chart recipe, we can now also see that the number of houses for sale in the mid-range market is very high, while the availability in the expensive market is very low.

主站蜘蛛池模板: 浮山县| 楚雄市| 灵寿县| 奉化市| 科尔| 禄劝| 陇南市| 岱山县| 宿迁市| 尼玛县| 拜城县| 灵山县| 昂仁县| 怀集县| 邻水| 甘洛县| 遂溪县| 泽州县| 监利县| 上林县| 观塘区| 卓尼县| 缙云县| 宁乡县| 永昌县| 陈巴尔虎旗| 精河县| 洛南县| 武邑县| 会宁县| 乌拉特前旗| 苏尼特左旗| 林西县| 大冶市| 安新县| 靖江市| 渝北区| 赤壁市| 溧水县| 玛沁县| 姜堰市|