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

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.

主站蜘蛛池模板: 宣武区| 吉林市| 襄樊市| 甘南县| 鄂伦春自治旗| 南和县| 佛坪县| 江门市| 乃东县| 荥阳市| 繁峙县| 延川县| 定南县| 遵义县| 惠安县| 延川县| 体育| 辽中县| 吉隆县| 黑山县| 普格县| 靖西县| 阿城市| 嵊州市| 塔河县| 五寨县| 岗巴县| 巴青县| 项城市| 南丰县| 安吉县| 甘孜| 隆安县| 大石桥市| 连平县| 新泰市| 富源县| 临清市| 若尔盖县| 泌阳县| 海南省|