How to Create a Bump Chart in Tableau

Tracking how things stack rank over time is a classic business problem. Whether you're watching your marketing channels compete for the top spot or tracking sales rep performance across quarters, seeing these changes clearly is vital. A bump chart is the perfect visualization for this, and this tutorial will walk you through exactly how to build one from scratch in Tableau.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is a Bump Chart and When Should You Use One?

A bump chart is a specific type of line chart designed to show how the rankings of different categories change over a period. Instead of "what was the exact sales figure?", it answers the question "who was #1, #2, and #3 this month, and how has that changed since last month?". Each line represents a distinct category, and its vertical position on the chart shows its rank at each point in time. When lines cross, it signifies one category has overtaken another in the rankings.

Because they focus on position rather than absolute value, bump charts are great for:

• Highlighting competition: Easily spot when challengers rise and leaders fall. It brings a narrative of competition to your data.
• Simplifying complex trends: If you have noisy data with lots of fluctuations, focusing on rank can smooth out the story and make it easier to understand.
• Comparing a limited number of categories: They work best when you have a manageable number of contenders (typically between 3 and 10). Any more than that, and you might get what's affectionately called a "spaghetti chart" - a tangled mess of lines.

Real-World Examples

You can use a bump chart to visualize:

• Your company's bestselling products by quarter.
• Website traffic performance of different social media platforms month-over-month.
• The Formula 1 constructor standings after each race in a season.
• Market share rankings of competing brands over several years.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Preparing Your Data for a Bump Chart

Before you even open Tableau, the success of your bump chart depends on having your data structured correctly. This will save you a world of headaches later. At a minimum, your dataset needs three core components:

1. A time dimension that shows progression. This could be a date, month, quarter, or year. In Tableau, this will typically be a field with a calendar icon.
2. A category dimension to identify what you are ranking. This is whose performance you're tracking - think of it as the "contestants" in your competition (e.g., 'Campaign Name', 'Sales Rep', 'Product Category').
3. A measure to determine the rank. This is the numeric value you'll use to decide who is #1, #2, etc. (e.g., 'Revenue', 'Sessions', 'Conversion Rate').

Here’s what a simple, ready-to-use dataset might look like:

Month,Marketing Channel,Leads Jan,Organic Search,1200 Jan,Paid Search,950 Jan,Email,1100 Feb,Organic Search,1350 Feb,Paid Search,1400 Feb,Email,1050 Mar,Organic Search,1500 Mar,Paid Search,1450 Mar,Email,1600

In this example, 'Month' is our time dimension, 'Marketing Channel' is our category, and 'Leads' is our measure. With data structured like this, you're ready to start building.

Step-by-Step Guide to Creating a Bump Chart in Tableau

With our data ready, let's jump into Tableau and build this chart. We'll use the sample marketing channel data from above.

Step 1: Get the Basic View on the Canvas

First, connect Tableau to your data source. Then, set up the basic structure of your chart.

• Drag your time dimension ('Month' in our case) to the Columns shelf. Right-click the blue pill and ensure it's set to a discrete value like month or quarter (it will show MONTH(Date) and be blue).
• Drag your category dimension ('Marketing Channel') onto the Color mark in the Marks card. This assigns a unique color to each of our channels, which is key for tracking them visually.

At this point, you won't see anything on the canvas yet, and that's perfectly fine. We haven't told Tableau what to plot.

Step 2: Create the Rank Calculation

This is the most important step. Bump charts don't plot the actual measure (like 'Leads'), they plot the rank of that measure. We need to create a calculated field to do this.

1. Go to the top menu and select Analysis > Create Calculated Field...
2. Name your calculation something intuitive, like "Rank of Leads".
3. In the formula box, use the RANK() function. The formula will be:

RANK(SUM([Leads]))

1. Click OK. This tells Tableau to sum the 'Leads' for each item and then assign a numerical rank based on that sum.

You’ll now see your shiny new "Rank of Leads" measure in the Data pane on the left.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 3: Add the Rank to the View

Now, let's put our new calculation to use.

• Drag your new "Rank of Leads" measure from the Data pane onto the Rows shelf.

As soon as you do this, you'll see a chart appear. It's likely a jumble of lines or dots, but don't worry - we're about to tame it. Eagle-eyed users might notice a little triangle icon on the "Rank of Leads" pill. This signifies it's a Table Calculation, which requires special configuration.

Step 4: Configure the Table Calculation (The Crucial Part!)

Currently, Tableau is probably ranking everything '1' or ranking across the entire table. We need to tell it how to calculate the rank. We want it to rank the 'Marketing Channels' against each other within each month.

1. Right-click the "Rank of Leads" pill on the Rows shelf.
2. Select Compute Using > Marketing Channel.

This action tells Tableau explicitly: "For each month, look at all the marketing channels and rank them against one another. Then move to the next month and do it all again." This is the key to making the chart work.

Step 5: Change the Mark Type and Invert the Axis

With the calculation configured, we just need to tidy things up for the classic bump chart look.

• In the Marks card, click the dropdown menu and change the Mark Type from 'Automatic' to Line. You should now see smooth lines connecting the points for each marketing channel across the months.
• By default, Tableau will put rank #1 at the bottom and the lowest rank at the top. We want the opposite. Right-click on the "Rank of Leads" axis on the left side of your chart and select Edit Axis...
• In the pop-up window, check the box for Reversed under the Scale options. Now rank #1 is at the top where it belongs.

Congratulations, you have a functional bump chart!

How to Customize Your Bump Chart for Clarity

A basic bump chart is good, but a great one is clear, insightful, and easy to read. Let's add some finishing touches.

Add Markers Using a Dual Axis

Adding circles at each data point makes it easier to pinpoint the rank at a specific moment in time.

1. Hold down Ctrl (or Cmd on Mac) and drag the "Rank of Leads" pill on the Rows shelf to its right. This creates a duplicate of the pill.
2. You now have two identical charts and two tabs in your Marks card ("SUM(Rank of Leads)" and "SUM(Rank of Leads) (2)"). Click on the second tab.
3. Change its Mark Type from 'Line' back to Circle.
4. Now, right-click on the second "Rank of Leads" pill on the Rows shelf and select Dual Axis.
5. Finally, right-click the right-hand axis and select Synchronize Axis to make sure both axes perfectly align. You can now hide this second axis by right-clicking it again and unchecking "Show Header."

Add Meaningful Labels

Labels can help your audience know which line is which, without constantly referring back to a legend.

• Drag your category dimension ('Marketing Channel') onto the Label button in the Marks card (for both the Line chart and the Circle chart if you used a dual axis).
• Labels might look cluttered. To fix this, click the Label button, and in the options, select 'Line Ends'. Then, check 'Label end of line' and uncheck 'Label start of line'. This often declutters the view significantly by showing the category name only by the final data point.
• You can also drag 'Rank of Leads' onto the Label mark to show the specific rank number inside each circle.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Clean Up Your Tooltips

A well-crafted tooltip provides extra context when a user hovers over a data point. Click the Tooltip button in the Marks card. You can edit the text to make it more readable, for example:

Channel: &lt,Marketing Channel&gt, Month: &lt,MONTH(Month)&gt, Rank: &lt,RANK(SUM([Leads]))&gt, Leads: &lt,SUM([Leads])&gt,

This shows the user not only the rank at that point but the actual measure value that determined the rank, adding another layer of depth.

Common Trouble Spots and How to Fix Them

• "All my ranks are '1'!" This is the most common issue. Your table calculation isn't set up correctly. Go back to Step 4 and ensure your 'Rank' pill on the Rows shelf is set to Compute Using > [Your Category Dimension].
• "My chart is a mess of lines." Bump charts are best for a small number of categories. If you have more than 10, consider filtering down to only the "Top N" to make the story clearer. Drag your category dimension to the Filters shelf, select the 'Top' tab, and set it to show the Top 10 by your measure.
• "My axis doesn't look like ranks." Make sure you edit the axis for your rank and set the scale to 'Reversed'. Also, in the same 'Edit Axis' window under Tick Marks, choose 'Fixed' and set the tick interval to 1. This will prevent Tableau from showing partial ranks like 1.5, 2.5, etc. and only show whole numbers.

Final Thoughts

This walkthrough shows that while building a bump chart in Tableau has several specific steps, it's very achievable once you understand the role of the RANK() table calculation. It’s an incredibly effective way to cut through numerical noise and tell a clear story about competition and change over time.

Mastering tools like Tableau is a valuable skill, but it often involves learning precise sequences of clicks, calculations, and settings just to build a single chart. For teams that need answers fast without the steep learning curve, the process can feel like a bottleneck. We built Graphed to solve exactly this frustration. Instead of a dozen manual steps, you can simply connect your data and ask, "show me a bump chart of my sales team rankings by quarter," and Graphed creates the interactive visualization instantly, giving you back time to focus on the insights, not the setup.