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

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.

主站蜘蛛池模板: 鄢陵县| 曲阳县| 怀化市| 郸城县| 察隅县| 绥芬河市| 抚顺市| 桃江县| 乌拉特后旗| 商南县| 平凉市| 普定县| 峨眉山市| 象州县| 全南县| 苗栗市| 大足县| 黄山市| 扎囊县| 安庆市| 石首市| 黄山市| 泸定县| 正定县| 任丘市| 天全县| 青龙| 类乌齐县| 和政县| 嵩明县| 房山区| 顺平县| 刚察县| 维西| 年辖:市辖区| 永安市| 高淳县| 菏泽市| 黄平县| 河源市| 曲麻莱县|