How to Make a Bubble Chart in Looker

Bubble charts are a powerful way to visualize three dimensions of data at once, making complex relationships easy to grasp at a single glance. They extend the classic scatter plot by using the size of the bubble to represent a third variable. This article will walk you through exactly what bubble charts are, when to use them, and how to create one step-by-step in Looker Studio (formerly Google Data Studio).

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Exactly is a Bubble Chart?

Think of a bubble chart as a souped-up scatter plot. Where a scatter plot uses two axes (X and Y) to show the relationship between two variables, a bubble chart adds a third dimension: size. This allows you to communicate more information in the same amount of space.

Here's the breakdown of its core components:

• The X-axis (Horizontal): Represents the first numeric value.
• The Y-axis (Vertical): Represents the second numeric value.
• Bubble Size: Represents the third numeric value. Larger bubbles indicate a greater value for this metric.

You can even add a fourth dimension by using color to categorize the bubbles, such as grouping them by marketing campaign, country, or product category. This transforms a simple chart into a rich, multi-dimensional story about your data.

When to Use a Bubble Chart: Practical Examples

Bubble charts shine when you need to compare entities across three different quantitative measures. They are fantastic for spotting patterns, outliers, and clusters of data points that warrant a closer look. They're not for every situation, but in the right context, they provide insights that are difficult to see with simpler charts.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Marketing Campaign Analysis

Imagine you're analyzing several marketing campaigns. A bubble chart can help you quickly identify the top performers.

• X-axis: Cost Per Acquisition (CPA)
• Y-axis: Conversion Rate
• Bubble Size: Total Spend or Total Conversions
• Bubble Color (Optional): Campaign Type (e.g., Social, Search, Email)

With this setup, you can instantly see which campaigns have a low CPA and a high conversion rate (the top left quadrant). The largest bubbles represent the campaigns you've invested the most in, helping you quickly assess whether that investment is paying off.

Sales Performance Evaluation

A sales manager could use a bubble chart to understand their team's performance over a quarter.

• X-axis: Number of Deals Closed
• Y-axis: Average Deal Size
• Bubble Size: Total Revenue by Sales Rep
• Bubble Color (Optional): Sales Team or Region

This visualization would highlight reps who close many small deals versus those who close fewer, but larger deals. The bubble size immediately tells you who's bringing in the most revenue, regardless of their strategy.

Website Content Engagement

A content marketer could analyze blog post performance to decide what to write next.

• X-axis: Average Time on Page
• Y-axis: Number of Pageviews
• Bubble Size: Number of Shares
• Bubble Color (Optional): Content Category (e.g., Guides, News, Case Studies)

Outlier bubbles would immediately show you which articles are both popular (high pageviews) and engaging (high time on page), with the bubble size indicating their virality. This helps you identify your most successful content formats and topics.

Get Your Data Ready for Looker Studio

Before you jump into Looker Studio, your data needs to be structured properly. A bubble chart requires, at a minimum, three numeric fields (metrics) or two metrics and one dimension. If you want to use color for categorization, you'll need a fourth field, which is typically a categorical dimension (like 'Campaign' or 'Country').

For a functioning bubble chart, your dataset should contain:

• One Dimension (Optional, but recommended for Bubble Color): This is the item you want to analyze, like Campaign, Landing Page, Sales Rep, or Product Name.
• One Metric for the X-axis: A numeric value like Average User Engagement, Cost, or Sessions.
• One Metric for the Y-axis: A numeric value like Conversions, Conversion Rate, or Total Revenue.
• One Metric for the Bubble Size: A numeric value that represents volume, like Total Users, Ad Spend, or Sales Volume.

For example, if you're using data from Google Analytics 4, a well-prepared dataset might have columns like Session source, Sessions, Conversions, and Total users.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Make a Bubble Chart in Looker Studio: Step-by-Step

Once your data is ready, creating the chart itself is a straightforward process. Let's walk through it together.

Step 1: Open Looker Studio and Connect Your Data Source

Start by navigating to lookerstudio.google.com and creating a new blank report. You'll then be prompted to add data to your report. Looker Studio has connectors for dozens of services, including Google Analytics, Google Sheets, BigQuery, and many more. Choose the data source where your information lives and connect it to your report.

Step 2: Add a Bubble Chart to Your Report

With your data source connected, go to the top menu and click Insert (or Add a chart). Scroll down the list of available chart types and select Bubble chart. Click anywhere on the report canvas to place it.

Looker Studio will automatically generate a bubble chart using some default fields from your data source. Don't worry if it looks wrong, we'll configure it in the next step.

Step 3: Configure Your Chart's Data Fields

This is where you tell Looker Studio how to build your visualization. With your new bubble chart selected, a Chart Properties panel will appear on the right side of the screen. Make sure you are in the Data tab.

Here, you will see several fields to populate. Let's use a marketing campaign example with Google Analytics 4 data:

1. Dimension: This field will define your bubbles. Drag Session campaign here. This will also be used for the bubble color by default.
2. X Axis Metric: This determines the horizontal position of each bubble. Drag a metric like Average session duration into this field.
3. Y Axis Metric: This sets the vertical position. Drag a metric like Conversions into this field.
4. Bubble Size Metric: This determines the size of each bubble. Drag a volume metric like Total users here.

Once you've dropped these fields into place, your chart will update in real time to reflect your selections. You should now see a bubble for each of your campaigns, positioned according to its average session duration and conversions, and sized by its total user count.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Customize the Chart's Appearance (Style Tab)

A working chart is great, but a beautiful and clear chart is even better. Navigate to the Style tab in the Chart Properties panel to fine-tune the aesthetics.

Here are a few key adjustments you can make:

• Color by: You can choose a single solid color for all bubbles or, more usefully, color by the 'Dimension' values you selected. This assigns a unique color to each campaign, store, or region, making the chart much easier to read.
• Number of Bubbles: If your chart is too cluttered, you can limit the number of bubbles shown here. Looker will display the top values based on your bubble size metric.
• Axes and Grid: Customize the look of your X and Y axes. You can add titles (highly recommended!), change the font color and size, and adjust grid lines to improve readability. Using axis titles like "Conversion Rate" and "Average Order Value" provides crucial context.
• Legend: Adjust the positioning and text styling of your legend so it's clear and doesn't get in the way of the data.
• Background and Border: Change the chart's background color and add a border or rounded corners to help it stand out on your dashboard.

Tips for Creating Effective Bubble Charts

Creating the chart is only half the battle. Presenting it in a way that viewers can quickly understand is the ultimate goal. Here are a few best practices:

• Don't Overcrowd the Chart: Bubble charts can become messy if you have too many data points. If you have hundreds of brands or campaigns, consider filtering to show only the top 10 or 20, or group smaller items into an "Other" category.
• Use Clear Labels: Direct data labels on the bubbles can be helpful, but they can also cause clutter. Use them sparingly or rely on tooltips (the information that appears when you hover over a bubble).
• Size Matters: Choose a bubble size metric that logically represents volume or impact. Total Revenue and Investment are great choices. Average Engagement Rate would be a poor choice for size since it isn't an aggregate value.
• Always Add a Title and a Legend: Your chart should be understandable on its own. A descriptive title like "Campaign Performance: Cost vs. Conversions (Q3)" tells your audience exactly what they are looking at. The legend is non-negotiable for explaining what the colors represent.

Final Thoughts

Building a bubble chart in Looker Studio is an accessible way to analyze three variables simultaneously, helping you uncover relationships that a simple table or bar chart would miss. By correctly configuring the X-axis, Y-axis, size, and color dimensions, you can transform complex data into a clear visual story that quickly highlights top performers and interesting outliers.

While mastering tools like Looker Studio is a valuable skill, we believe getting insights from your data shouldn't require manual configuration. At Graphed, we’ve created an AI data analyst that streamlines this process entirely. Instead of dragging and dropping fields, you simply ask in plain English: "Show me a bubble chart of ad spend vs conversions by campaign for last month, with bubble size based on impressions," and get an interactive, real-time chart built for you in seconds. It allows you to skip straight to the insights and explore your data conversationally, freeing you up to focus on making better decisions, faster.