A bump chart is a type of visualization that is used to compare the relative positions of categories over time. It is a simple but effective way to show changes in rankings or to highlight trends and outliers in a data set. Thus, today, I’m going to show you how to make a bump chart by using tableau.

  1. Take superstore data set as example, connect to the Superstore data set in Tableau and create a new worksheet.
  2. Drag the “Order date” dimension to the Columns shelf and the “Sales” measure to the Rows shelf. And also drag region to color. 
  3. Right-click on the “Sales” field in the Columns shelf and select “Add Table Calculation”, In the “Table Calculation” dialog box, choose “Rank” as the calculation type, and select “Descending” as the order. select the option Compute Using and then select Region.
  4. Next, we want to edit the axis, double click on the y-axis and change the scale to reversed.
  5. Next, duplicate our measure SUM(Sales) and make it dual axis and also synchronize the axis to make the axis consistent.
  6. Change the mark type to circle and click on the Show mark labels and select the right format to make the label inside the circles. Then, we have our easy bump chart. 
The Data School
Author: The Data School