Create a Bubble Chart using Caxpy

A bubble chart is a type of chart that displays three dimensions of data. Bubble charts can be considered a variation of the scatter plot, in which the data points are replaced with bubbles. As the documentation for Microsoft Office explains, "this type of chart can be used instead of a Scatter chart if your data has three data series, each of which contains a set of values"

 

To create a Bar chart you need to have at least one text column and two number column.  The first number column depicts the actual value on the graph that the chart depicts and the other number column depicts the radius of the bubble.

 

Take for the above plot of columns. The Store Sales depicts the value on the plot  and that fact count will represent the size of the bubble. Its is not necessary to provide the second number column, in that case the bubble column will look like a scatter plot.

Lets take another example to understand how the bubble plotting works. Suppose I have a table of List of largest Internet companies, with their Market capital and their revenues. This data in our pivot would look like the table shown below.

When we convert this table data into Bubble it looks like this -

 

 

The same when converted into a scatter plot looks like this