• Bernard

Tableau charts: Bump chart

Updated: May 28


The series, Tableau charts has always focused on one thing, helping Tableau users learn how to create different charts and graphs hence equipping them with different techniques of telling each data story.

Inspired by the mission of this series, this post will help you learn how to create a Bump chart using Superstores data set pre-loaded in Tableau app, our goal is to visualize how Product Sub-category's have performed in Sales for different months of the year by ranking them.

But,.. first lets create a calculated field to Rank Sales along the Sub-category's.

Under, 'Default Table Calculation'. Compute the Table rank using Sub-category. See below.

Lets build our chart.

  • Drag dimension field Order Date to the Columns shelf. Change the level of detail from Year to Month.

  • Drag dimension field Sub-Category to the Detail tab under the marks card.

See the resulting chart.

  • Next, Drag the Calculated field Rank above to the Rows shelf, see the results below.

Duplicate the chart by (hold down Ctrl key) dragging the field Rank on the Rows shelf next to itself. See below.

Make the charts dual and synchronize the axis.

Note that the axis are in reverse, to correct this.

  • Right click on the axis >> Edit axis.. >> select Reversed under Scale.

See the resulting chart. (With ranks, arranged accordingly).

Select the Second chart and change the chart type to a Circle, make sure the First chart remains to be a Line.

Drag, the field Sub-category to the color tab under the marks card for both the charts.

Select the second chart (Circles). Drag calculated field Rank to the Label tab, Open the Label tab and align the labels to the middle center. See below.

Doing some formatting and editing we've.

And there we have it. From the above chart, it is clear that Fasteners' were ranked last across all the months (It's a product with few Sales), while Phone's & Chair's ranks, varied between one and three (These are products with huge Sales).

I hope this article was useful to you.

Thanks for reading.

#charts