How to Make a Bubble Chart in Tableau

Bubble charts are a fantastic way to tell a multi-dimensional story with your data, packing three different metrics into one clear visual. If you’ve ever wanted to show the relationship between variables like sales, profit, and customer count all at once, you’re in the right place. This guide will walk you through exactly how to create, customize, and effectively use a bubble chart in Tableau.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

What is a Bubble Chart and When Should You Use It?

Think of a bubble chart as a souped-up scatter plot. A scatter plot uses X and Y axes to show the relationship between two variables. A bubble chart adds a third dimension to the mix by varying the size of the data points (the bubbles). This allows you to compare and contrast data points based on three different numerical values simultaneously.

Here’s a breakdown of its parts:

• The X-Axis Position: Represents the value of a specific measure.
• The Y-Axis Position: Represents the value of a second measure.
• The Bubble Size: Represents the value of a third measure. The bigger the bubble, the higher the value.
• Color (Optional): A categorical dimension can be added to the mix, where each category gets its own distinct color.

This structure makes them excellent for visualizing data when you need to understand complex relationships in your business. You might use one to:

• Analyze Product Performance: Compare different product categories by plotting Total Sales (X-axis), Profit Margin (Y-axis), and Number of Units Sold (bubble size). This immediately shows you which products are both high-selling and highly profitable versus those that sell a lot but have low margins.
• Evaluate Marketing Campaigns: Visualize campaign effectiveness by showing Ad Spend (X-axis), Conversion Rate (Y-axis), and Total Conversions (bubble size). You can quickly spot a campaign that might have a high conversion rate but low total conversions, suggesting it needs more budget.
• Assess Regional Sales: Plot sales regions to see Revenue per Customer (X-axis), Customer Acquisition Cost (Y-axis), and total Number of Customers (bubble size) for each region.

However, they aren't always the perfect choice. Avoid bubble charts if you have too many data points (it can become a cluttered mess), or if the third variable (size) includes negative numbers, as bubble size cannot be negative.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Preparing Your Data for a Bubble Chart

Good visualizations start with good data. Before you jump into Tableau, make sure your dataset is structured in a way that makes sense for a bubble chart. Ideally, your data file (like an Excel or CSV file) should have:

• At least one dimension: This is a categorical field that you'll use to define what each bubble represents. Think of things like Product Category, Country, Campaign Name, or Sales Rep.
• At least two or three measures: These are the numerical values you want to analyze. You need a minimum of two (for the X and Y axes), but a third measure is what makes it a bubble chart (for the size). Examples include Sales, Profit, Quantity, Spend, or Click-Through Rate.

For example, a simple dataset to analyze e-commerce product performance might look something like this:

With this structure, we can easily plot Sales, Profit, and Order Count for each Product Category.

Step-by-Step Guide: Creating Your First Bubble Chart in Tableau

Let's build a bubble chart using the Tableau Superstore sample dataset. Our goal is to see how different Product Sub-Categories perform based on their total Sales, Profit, and the Quantity of items sold.

Step 1: Connect to Your Data

First, open Tableau Desktop. From the connect pane on the left, find and connect to your data source. For this tutorial, we will use the "Sample - Superstore" dataset that comes with Tableau. If you just opened the software, you should be able to click on it under "Saved Data Sources."

Step 2: Add Measures to Rows and Columns

Once your data is loaded, a new worksheet will open. In this view, you have your Dimensions and Measures on the left pane. We are going to start this just like a scatter plot.

• Drag the Sales measure to the Columns shelf.
• Drag the Profit measure to the Rows shelf.

Tableau will automatically create a single lonely-looking dot on a scatter plot, showing you the grand total for sales and profit.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 3: Break Down the View with a Dimension

That single dot isn't very useful, we need to see the performance of each product sub-category. To do this:

• Find the Sub-Category dimension in the side pane.
• Drag Sub-Category and drop it onto the chart canvas.

Tableau's "Show Me" capability will likely interpret this and create a scatter plot with a point for each sub-category. Now you have a clear picture of sales vs. profit broken down properly.

Step 4: Incorporate the Third Measure for Bubble Size

This is where our scatter plot transforms into a bubble chart. We will use the Quantity measure to dictate the size of each bubble.

• On the Marks card (typically in the middle left of the screen), you’ll see several properties like Color, Size, Label, etc.
• Drag the Quantity measure from the Measures list and drop it directly onto the Size property in the Marks card.

You’ll immediately see your data points change into bubbles of varying sizes. Sub-categories with a higher total quantity of items sold will have larger bubbles. And just like that, you've created a bubble chart!

Step 5: Add Color and Labels for Clarity

The chart works, but it can be much easier to read. Let’s add color to differentiate the overall Category each sub-category belongs to and add labels so you know which bubble is which.

• For color: Drag the Category dimension from the Dimensions list and drop it onto the Color property in the Marks card. Tableau will assign a unique color to each of the main product categories (e.g., Furniture, Office Supplies, Technology).
• For labels: Drag the Sub-Category dimension and drop it onto the Label property in the Marks card. This will display the name of each sub-category next to its bubble.

Now your chart is fully functional, visual, and easy to understand at a glance.

Customizing and Enhancing Your Bubble Chart

Building the chart is just the first step. To make it truly insightful, you’ll want to apply some finishing touches.

Adjusting Tooltips

A tooltip is the small box of information that appears when you hover over a data point. Tableau pre-populates it, but you can customize it to be more useful.

1. Click on Tooltip in the Marks card.
2. An editor window will pop up where you can change the text.
3. You can add clearer descriptions, remove unnecessary fields, and format the numbers. For example, you can format the Sales and Profit values to be displayed as currency.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Fine-Tuning Bubble Size

Sometimes, the default sizing of the bubbles isn't quite right, they're either too similar or the differences are too extreme.

1. Click on Size in the Marks card.
2. A slider will appear. You can drag it to globally increase or decrease the size of all bubbles to improve readability.

Adding Analytics - Like a Reference Line

Want to see which products are below the average profit mark? Adding a reference line can provide quick context.

1. Go to the Analytics pane next to the "Data" pane on the left.
2. Drag Average Line from the pane and drop it onto the chart canvas.
3. A box will appear asking where you want to add the line. Choose Profit to add a horizontal line representing the average profit across all sub-categories. Now you can instantly see which bubbles fall above or below the average.

Common Mistakes to Avoid

As powerful as bubble charts are, a few common pitfalls can make them confusing or misleading. Here are a few to watch out for:

• Overplotting: This happens when you try to display too many bubbles on one chart. They start overlapping, and the visualization becomes an illegible cluster. If you have hundreds of categories, consider filtering down to the most important ones or grouping smaller ones into an "Other" category.
• Using Negative Values for Size: A bubble can't have a negative size. If your sizing measure (like 'Profit') contains negative values, Tableau won't be able to render those bubbles. In these cases, consider using color to represent negative values (e.g., positive profit is blue, negative is red) instead of size.
• Poor Labeling: An unlabeled chart is a mystery. Always make sure your axes are clearly titled, and each bubble is identifiable either through a direct label or a clear tooltip.

Final Thoughts

Building a bubble chart in Tableau is a simple process of dragging and dropping your measures and dimensions, but the result is a sophisticated visual that can reveal deep insights. By mapping three variables at once, you can quickly analyze performance, spot outliers, and understand the complex relationships within your business data.

While mastering tools like Tableau is a huge advantage, we built Graphed because sometimes you need answers without the manual setup. Instead of dragging fields to shelves and Marks cards, you can just ask a question in plain English. For example, you could type "create a chart comparing Sales vs Profit for each Sub-Category, and use Quantity for the bubble size." Graphed instantly builds the live, interactive visualization, helping you and your team get data-driven insights in a matter of seconds.