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

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.

主站蜘蛛池模板: 安丘市| 鲁山县| 昌黎县| 修水县| 大埔县| 易门县| 神木县| 丰镇市| 新巴尔虎左旗| 乐业县| 曲水县| 来安县| 沾化县| 双峰县| 政和县| 阜宁县| 潞城市| 新巴尔虎左旗| 拜泉县| 大新县| 卢氏县| 长垣县| 沈阳市| 东莞市| 讷河市| 鄂温| 阿合奇县| 东城区| 靖西县| 财经| 关岭| 周宁县| 尼木县| 福鼎市| 黔江区| 井陉县| 姜堰市| 西乌珠穆沁旗| 大英县| 襄城县| 启东市|