Bubble plots are similar to Scatterplot charts, but support three value series instead of two. The first column maps to the x-axis, the second column to the y-axis, and the third column becomes the area of the bubble.
Add an optional fourth and/or fifth column: a fourth column will become the bubble’s label, and a fifth column will be a category (and group the bubbles with separate colors.)
Max bubble size
Set the maximum bubble size in the Series tab of your chart settings.
Required dataset format:
Between 3 and 5 columns. Columns 2 and 3 must be numeric. If 5 columns, first column must be a date or a number.
|Column 1||Column 2||Column 3|