Relationship > Three or More Variables | Difficulty: Medium
.
TABLEAU
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
INSERT > CHART > INSERT SCATTER OR BUBBLE CHART > BUBBLE