An on-line library for creating different chart types in Tableau

Scatter Plot with Size

Tableau Canvas Layout:

A scatter plot with size will typically have three Measures, one on the Columns, one on the Rows, and one on Size in the Marks Card.

Data Set: World Indicators Data

Building a Scatter Plot with Size

Using the World Indicators data:

     Double-click Life Expectancy Female to move it to Rows      Double-click Birth Rate to move it to Columns.
     Right-click on Life Expectancy Female on the Rows, select "Measures (Sum)" and change it to Average.
     Right-click on Birth Rate on the Rows, select "Measures (Sum)" and change it to Average.
     Double-click Country to move it to Details on the Marks card.
     Move Region to Color on the Marks card.
     Move Population Total to Size on the Marks card.
     Using the dropdown box on the Marks card, select "Circles".
     Double-click the y-axis and select "Fixed" and set the "Fixed Start" to 40.

You should now have a scatter plot similar to the image below.

Adjusting size and color

     Select Size on the Marks card and adjust the size to make the circles larger.
     Select Color on the Marks card and set Opacity to 65%.
     Select Border and pick a medium gray color.

Note - the opacity and border is a useful tool when lots of dots plot on top of each other.

Creating Animation

     Move Year to Pages.

You now have recreation of the famous Gapminder visualization by Hans Rosling. Click the play control buttons to see the visualization animate over time.

Related Material:

A full version of this visualization with a larger dataset is available for download from Tableau Public by Jeffrey A. Shaffer
A video of Han's Rosling Gapminder recreated in Tableau on YouTube by Jeffrey A. Shaffer
My Tableau Voice video with instructions on how to build Gapminder in Tableau by Jeffrey A. Shaffer
Z-Order in Tableau by Jeffrey A. Shaffer (how to control the order of dots on top of each other)

Return to the chart gallery