Bubble Plot

Relationship > Three or More Variables | Difficulty: Medium
.

TABLEAU

ENERGY USE VS CO2 EMISSIONS BY COUNTRY
SIZE: GDP/CAPITA

COLUMNS: Measure
ROWS: Measure (different)

MARK
SIZE: Measure (also different)
DETAIL: Dimension to identify (optional)
COLOR: Dimension to group (optional)

WHAT IS A BUBBLE PLOT?

A bubble chart (aka bubble plot) is an extension of the scatter plot used to look at relationships between three numeric variables. Each dot in a bubble chart corresponds with a single data point, and the variables’ values for each point are indicated by horizontal position, vertical position, and dot size.

WHEN TO USE A BUBBLE PLOT

Like the scatter plot, a bubble chart is primarily used to depict and show relationships between numeric variables. However, the addition of marker size as a dimension allows for the comparison between three variables rather than just two.

Sources: Chartio

EXCEL

X vs Y vs Z (size) by NORTH/SOUTH (color)

INSERT > CHART > INSERT SCATTER OR BUBBLE CHART > BUBBLE

Design a site like this with WordPress.com
Get started