Bump Chart in Tableau

BUMP CHART

Bump chart is a form of line chart designed for exploring changes in rank over period of time. This chart is normally used to compare the ranking of any dimension based on a particular measure value.

HOW TO BUILD A BUMP CHART IN TABLEAU?

This blog will detail how to make a bump chart using sample-Superstore data.

To create bump chart in Tableau, we are using two dimensions and one measure. In this dataset, we are using order date and region as dimensions and Sales as measure. Here I am analyzing the data only for the year 2021.

Image by author

For that, I am putting the order date into filters to get the data only for the year 2021.

Image by author

Here you can see the line chart for all the region by sales. Now, we want sales to show the ranking of the region. For this, select Rank in the quick table calculation as shown in the image below.

Image by author

Click on the compute using and region as shown.

Image by author

We will get sales by region and ranking is based on the sales.

Image by author

To make it look like a bump chart, we are duplicating the measure Sum(sales) as below. Also, we are changing the second output in circles.

Image by author

Dual chart is used for various purposes. Here we are using it for the purpose of formatting. Go to Dual axis to merge these two charts.

Image by author

Image by author

We can format our chart by changing the color and size.

We can also add ranks to the circles by the changing the alignment in the Label. Here, I am putting the ranks in the middle of the circles.

On completion of the above steps, we will get the bump chart as shown in the following image. It shows the variation of sales for each region over a period of time.

Image by author

Bump chart is built using ranks that displays the ranks on the chart itself.