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.