TabCharts.com

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



Unit Chart





Tableau Canvas Layout:




Unit charts, also known as Wilkinson Dot Plots, are similar to bar charts and histograms. However, they display each unit of measure as a single mark or symbol.

Data Set: Stacked Unit Chart Dataset



Building an Unit Chart


Opening the Stacked Unit Chart dataset

   Move Country to Rows
   Right-click on Country and create Bin, set the bin size to 1
   Change Marks card to Square. Move Country to Color.

You should now have a view that looks like this:



NOTE: Once you use a bin once on a sheet, it will not default to "Show Missing Values", so will need to change this each time you use the bin for data densification on a new sheet.

Formatting the Color


Normally with all these steps above, we already have a simple unit chart. However, we still can format its color to showcase some comparisons.

   Right-click on Bottom in the Country column and select Hide.
   Right-click on Top in the Country column and select Hide.
   Right-click on the X-Axis at the top and select Remove Header

Create a calculated field:
   Calculated Field: Index
   Formula: index()

Drag Index to Label and you will see Tableau count from 1 to 100 for each row of data, even though there is only one value for Count in each row. The sum(Count) is NULL in all of the other columns. We will leverage this to format our colors.

Create a calculated field:
   Calculated Field: Color
   Formula: isnull(RUNNING_SUM(Sum([Count]))) or index() = Sum([Count])

You should now have a Unit Chart that looks like this:





Related Material:


Data Densification Using Domain Completion and Domain Padding
Bin There, Done That
How to Make Unit Charts with Continuous Measures in Tableau


Return to the TabCharts.com chart gallery