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:
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:
How to do it...
Drag a Bubble Plot Chart component into the canvas.
Bind the data By Range to spreadsheet cells B5 through D9.
Bind the Chart field to cell A1 and delete the subtitle.
Bind the Value (X) Axis field to cell B4 and the Value (Y) Axis field to cell C4.
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.
