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

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.

主站蜘蛛池模板: 克山县| 靖江市| 邳州市| 隆昌县| 色达县| 自贡市| 贵阳市| 友谊县| 阿坝县| 响水县| 顺义区| 新营市| 芒康县| 西华县| 阳城县| 九江县| 河西区| 蓬莱市| 渭源县| 永安市| 成武县| 佛坪县| 喜德县| 涞源县| 阿鲁科尔沁旗| 德惠市| 奉新县| 简阳市| 安西县| 攀枝花市| 瑞丽市| 鄯善县| 肇州县| 嫩江县| 舞钢市| 尤溪县| 中阳县| 湖南省| 邻水| 麟游县| 江口县|