How to Make a Bubble Chart

A bubble chart is one of the best ways to tell a three-part story with your data. Instead of being limited to a simple bar graph or line chart, a bubble chart lets you visualize the relationship between three different variables at once on a single graph. This guide will walk you through exactly what a bubble chart is, when to use one, and how to create one step-by-step in common tools like Excel and Google Sheets.

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 Exactly Is a Bubble Chart?

Think of a bubble chart as a souped-up scatter plot. A standard scatter plot uses two axes (X and Y) to plot data points and show the relationship between two variables. A bubble chart adds a third dimension: the size of the data points themselves (the bubbles).

Here’s the breakdown of its three key components:

• X-Axis (Horizontal): Represents the first numerical value.
• Y-Axis (Vertical): Represents the second numerical value.
• Bubble Size: Represents the third numerical value. A larger bubble means a larger value.

For example, you could analyze marketing campaigns by plotting their cost on the X-axis, the number of conversions on the Y-axis, and the total revenue generated as the size of the bubble. Instantly, you can spot campaigns that are low-cost, high-conversion, and high-revenue — your big winners. You can also easily see the expensive campaigns with small revenue bubbles, which might need a second look.

Optionally, you can even add a fourth variable using color. In our marketing example, you could color-code a bubble for each marketing channel (e.g., blue for Google Ads, green for Facebook Ads), giving you another layer of immediate insight.

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

When Should You Use a Bubble Chart?

Bubble charts are fantastic for comparing items or categories based on multiple metrics. They help you quickly identify outliers, clusters, and relationships that would be much harder to spot in a spreadsheet or table. However, they aren't right for every situation.

Best Use Cases for a Bubble Chart:

• Analyzing Business or Marketing Performance: This is a classic. Compare marketing campaigns by cost, clicks, and conversion rate, or analyze product sales by units sold, price, and total profit margin.
• Visualizing Financial Data: Plot investments by risk (X-axis), expected return (Y-axis), and amount invested (Bubble Size).
• Comparing Market Segments: Evaluate different customer segments based on their size, average spend, and growth potential.
• Project Management: Assess a portfolio of projects by comparing their cost, timeline, and strategic value to the company.

When to Avoid A Bubble Chart:

• Too Many Bubbles: If you try to plot hundreds or thousands of data points, your chart will become a cluttered, unreadable mess of overlapping bubbles. For large datasets, it's better to aggregate your data or use a different chart type.
• Data Dimensions Are Too Similar: If the values for your bubble sizes are all very close, it will be hard to visually distinguish between them. The impact is lost.
• Negative Values for Size: The "size" of a bubble can't be negative. If your third dimension includes negative numbers, a bubble chart won't work.
• When a Simpler Chart Will Do: Don't overcomplicate things. If you're only comparing two variables, a scatter plot is better. If you’re just comparing a single metric across categories, a bar chart is clearer.

How to Organize Your Data for a Bubble Chart

Before you can build your chart, you need to structure your data correctly. This is the most important step. Your spreadsheet should have at least three columns, each representing one of the dimensions you want to visualize.

Let's use a sample dataset to analyze sales performance for different products. Your data should be organized in a table like this:

Column 1: X-Axis Data (e.g., Units Sold) Column 2: Y-Axis Data (e.g., Price per Unit) Column 3: Bubble Size Data (e.g., Total Revenue)

Here’s what that looks like in practice:

Example Data Table:

Notice that for the creation of the chart, we primarily need the three columns of numeric data. The "Product" column will be used for labels.

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

How to Create a Bubble Chart From Your Data

Once your data is properly formatted, creating the chart is relatively straightforward in most spreadsheet tools.

How to Make a Bubble Chart in Microsoft Excel

Excel makes it simple to turn your organized data into a bubble chart.

1. Select Your Data: Highlight just the cells containing the numerical data for the X-axis, Y-axis, and Bubble Size. In our example table, that would be the three columns from "Units Sold" to "Total Revenue."
2. Insert Chart: Go to the Insert tab on Excel's ribbon. In the Charts section, click on the icon that looks like a scatter plot (dots scattered on a grid).
3. Choose Bubble Chart: A dropdown menu will appear. You will see options for Scatter plots and below them, options for Bubble charts. Choose either the standard Bubble chart or the 3-D Bubble chart. The standard 2-D version is usually easier to read.
4. Voila! Excel will automatically generate the bubble chart. The first column you selected ("Units Sold") will be the X-axis, the second ("Price per Unit") will be the Y-axis, and the third ("Total Revenue") will determine the bubble sizes.

After creating the chart, you'll want to add context. Click on the chart, and you'll see a plus (+) icon appear on the right side. Click it to add chart elements like Axis Titles, a Chart Title, and Data Labels to make your visualization easy for others to understand. A good title might be "Product Performance: Units Sold vs. Price & Revenue."

How to Make a Bubble Chart in Google Sheets

The process in Google Sheets is very similar to Excel's.

1. Select Your Data: Highlight all the data you want to use, including the text labels in the first column (e.g., from "Product" down to the last row).
2. Insert Chart: Click on Insert in the top menu, then select Chart.
3. Select Bubble Chart Type: Google Sheets will often try to guess the chart you want to make, but it might not get it right. In the Chart editor pane that appears on the right, click the dropdown under Chart type. Scroll down to the "Scatter" section and select Bubble chart.
4. Configure Your Data: Google Sheets might try to auto-configure your data ranges, but you should double-check them in the editor.

• X-Axis: Should be your first numerical column (Units Sold).
• Y-Axis: Should be your second numerical column (Price per Unit).
• Series: This will also be the Y-Axis data.
• ID: This should be your text label column (Product).
• Size: This should be your third numerical column (Total Revenue).

Just like in Excel, use the Customize tab in the Chart editor to add a title, label your axes, and adjust colors to make the chart clear and professional.

Bubble Charts in BI Tools (Tableau, Power BI)

For more complex analysis, Business Intelligence tools like Tableau or Power BI offer much more flexibility. While the interfaces differ, the core concept remains the same.

In these platforms, you typically connect to your data source and then drag and drop the fields you want to visualize onto a canvas.

• You would drag your X-axis metric (e.g., 'Units Sold') to the Columns shelf.
• You would drag your Y-axis metric (e.g., 'Price per Unit') to the Rows shelf.
• You would drag your size metric (e.g., 'Total Revenue') onto the Size property in the "Marks" card.
• You could drag a categorical field (e.g., 'Product Category') onto the Color property to add a fourth dimension.

The major advantages of BI tools are their abilities to handle massive datasets, add interactive filters, and update automatically as your source data changes.

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

Tips for Making Your Bubble Chart Extra Effective

Creating the chart is half the battle. Presenting it in a way that’s easy to understand is just as important.

• Start With WHY: Before you even open Excel, ask yourself: What question is this chart trying to answer? A clear purpose will guide all your design and labeling choices.
• Don’t Make It Crowded: Fewer bubbles are better. If you have too many data points, they'll overlap and hide the story. Try grouping smaller items into an "Other" category or filtering to show only the top 10-15 items.
• Use Color With a Purpose: Color is great for a fourth variable (like a product category or region), but avoid using random colors that don’t mean anything. A consistent color scheme makes your chart cleaner.
• Label Strategically: You don't have to label every single bubble. Label the most important ones - the outliers, the winners, the losers - and let the viewer explore the rest. Clear axis titles and a descriptive main title are essential.
• Provide Context and a Legend: What do your axes represent? What does bubble size mean? Make sure this is obvious by using labels and legends. It should be clear that a bigger bubble is better (or worse, depending on your data). Tell the viewer how to read your chart.

Final Thoughts

Bubble charts are an exceptionally useful tool for visualizing data with three dimensions. They transform a flat spreadsheet into a dynamic visual story, allowing you to quickly spot trade-offs, identify high-performers, and find patterns you would have otherwise missed. With foundational tools like Excel and Google Sheets, building one is more accessible than ever.

Of course, making a single chart from a CSV is one thing, keeping reports updated with live data from all your different marketing and sales platforms is another challenge entirely. The typical routine of downloading files and manually rebuilding charts each week takes hours away from actual analysis. We built Graphed to automate that entire process. You connect tools like Google Analytics, Shopify, or Salesforce once, then just ask for the visualization you need in plain English — for example, “create a bubble chart showing campaign cost versus conversions, with bubble size based on revenue.” It builds live, interactive dashboards for you in seconds, so you can focus on finding insights, not wrestling with spreadsheets.