How to Make a Bubble Chart in Google Sheets with ChatGPT

Creating a bubble chart in Google Sheets is a fantastic way to visualize three different data dimensions at once, adding a layer of insight that standard charts can't match. It’s like a scatter plot that got a promotion. This tutorial will walk you through setting up your data, building the chart-step by-step in Google Sheets, and show you how to use ChatGPT to speed up the process.

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 Exactly is a Bubble Chart (And Why Use One)?

Think of a standard scatter plot, which plots data points using an X-axis (horizontal) and a Y-axis (vertical). A bubble chart takes this a step further by introducing a third dimension, represented by the size of each data point, or "bubble."

This allows you to compare and contrast data sets in a much richer context. You can quickly see relationships and identify outliers across three different variables simultaneously.

Here’s what each part represents:

• X-Axis Position: Measures the value of your first variable.
• Y-Axis Position: Measures the value of your second variable.
• Bubble Size: Measures the value of your third variable.

Bubble charts are extremely useful for tasks like:

• Marketing Analysis: Comparing marketing campaigns by cost (X-axis), conversion rate (Y-axis), and total revenue generated (bubble size).
• Project Management: Visualizing tasks by estimated effort (X-axis), potential impact (Y-axis), and required budget (bubble size).
• Sales Performance: Analyzing sales reps by the number of closed deals (X-axis), average deal size (Y-axis), and total revenue (bubble size).

Step 1: Get Your Data Ready

The trickiest part of making a bubble chart is ensuring your data is structured correctly. If your spreadsheet isn't set up properly, Google Sheets will get confused. You need your data organized into specific columns representing each aspect of the bubble chart.

For a bubble chart to work, your data must include at least four columns:

1. Bubble ID/Label: The name of the category for each bubble (e.g., Campaign Name, Product, Sales Rep).
2. X-axis data: The numerical values for the horizontal axis.
3. Y-axis data: The numerical values for the vertical axis.
4. Bubble Size data: The numerical values that will determine the size of each bubble.

Make sure all your values for the X-axis, Y-axis, and Size are formatted as numbers. If they're formatted as text, the chart won't be able to plot them correctly.

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

Using ChatGPT to Structure and Generate Sample Data

Don't have a dataset ready or just want to practice? You can use ChatGPT to instantly generate perfectly structured sample data for your chart.

Let's say we want to analyze the performance of several social media platforms. We can ask ChatGPT to act as a marketing analyst and generate the data we need.

Here’s a great prompt you can use:

Act as a marketing analyst. I am creating a bubble chart to compare 10 different social media platforms. Please generate a sample dataset in a clean table format with the following four columns: Make the data realistic for popular platforms.

ChatGPT will likely return a neatly formatted table. Here's an example of what that output might look like:

Now, simply copy this data from ChatGPT and paste it into a blank Google Sheet. A pro tip is to use Edit > Paste Special > Values only to avoid carrying over any strange formatting.

Step 2: Creating the Bubble Chart in Google Sheets

Once your data is in Google Sheets, creating the actual chart takes just a few clicks. Follow these steps:

1. Select Your Data

Click and drag your cursor to highlight the entire data set, including the header row.

2. Insert the Chart

With your data selected, navigate to the top menu and click Insert > Chart.

Google Sheets will automatically try to guess which type of chart you want. It probably won’t pick a bubble chart on its own, so we need to change it.

3. Choose the Bubble Chart Type

The Chart editor sidebar will appear on the right side of your screen. In this new panel, find the ‘Chart type’ dropdown menu.

Scroll down until you find the "Scatter" category and then select the Bubble chart option.

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

4. Set Up Your Bubble Chart Axes and Size

This is where you tell Google Sheets which column of data corresponds to which part of the chart. If you've laid your data out like we did earlier in this post, Google Sheets does an amazing job auto-selecting the right columns for your chart variables, but if your setup is slightly different than ours (or you see a variable mismatched), you can easily adjust them manually from the setup tab.

Here’s how to map everything correctly:

• X-axis: Confirm this is set to your horizontal axis data (e.g., ‘Monthly Active Users’).
• Series: Select your Y-axis data here (e.g., ‘Avg. Engagement Rate’).
• ID: Choose the column with your category labels (e.g., ‘Platform Name’). This ensures each bubble is identifiable.
• Size: Finally, select the column that dictates the size of your bubble charts (e.g., ‘Est. Ad Revenue’).

After adjusting the data correctly, your bubble chart should appear on your screen, ready to be customized.

Step 3: Customizing Your Bubble Chart for Clarity

An amazing chart not only tells a clear, focused narrative around your data but also needs to visually present itself in a way readers can easily understand and digest the information. After building out the initial chart shell, we need to tidy it up and refine how the chart is presenting itself within the Chart editor for greater clarity. To navigate over to the style settings just click on the "Customize" tab. From here, we will have access to several features to update like the:

• Chart & axis titles: Always add a clear title to your graph and never forget to label both axes. It adds additional clarity to your message and what the audience is looking at.
• Series: Update the color of the bubble, opacity, size change, etc., and find new ways to bring visual flair into your narrative. Additionally, you can add data labels to give readers the value represented with each data bubble, but you can risk your chart becoming cluttered-looking or illegible.
• Legend: Position or hide your legend if it doesn't give a deeper meaning and will appear cluttered.
• Horizontal & vertical-axis: Update titles, font sizes, colors, and much more here. You can adjust the minimum or maximum value range, which will allow you to focus the viewer's attention on a particular part of the chart.
• Guidelines & ticks: Sometimes using these features can confuse your audience if displayed. We recommend updating the major guidelines to give some structure but hiding away unnecessary ones unless the narrative needs them, as they can make your chart look cluttered and distract users from your primary message. With ticks, depending on the chart, these can be removed or, if you want them on, make sure they fit with the layout and feel balanced to the eye.

Sharing and Publishing Your Chart

Once you're happy with your creation, click the three small vertical dots in the upper-right corner of the chart. From there, you can:

• Download the chart as an image (PNG, JPG) or vector file (SVG).
• Publish the chart to the web, creating a live, shareable link.
• Move it to its own sheet for a larger view or to include it in a dashboard.

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

Interpreting the Insights in Your Bubble Chart

The real value of your chart is the story it tells. With our social media example, you can see a few things at first glance. Each of the quadrant sections provides unique insights, enabling deeper investigation or quickly identifying a platform's success.

For example, you could say that: “Our chart highlights TikTok and WhatsApp as clear standouts since both platforms sit in higher parts of our chart. Even with a smaller customer base, the engagement numbers are much stronger than a bigger platform like Facebook." Then, with an adjustment on your X & Y axis view range, say you had three distinct quadrants representing: Champions, Hidden Gems, and Risky Bets, each representing a unique segment that tells part of the bigger brand narrative.

Ask questions like:

"Are any of the larger bubbles in an unusual position?" or "Is a platform that brings in a lot of money not generally good at capturing engagement or having a massive active user base? That platform could potentially be a big return on investment and could become a major champion."

If you're unsure about how to interpret a chart, ChatGPT can help there too. You can describe the chart's findings or even paste the data back into the chat and ask: "Based on this data, what are the three most interesting insights a marketing manager should know?" It can provide a solid starting point for your analysis.

Final Thoughts

You’ve now learned how to create, customize, and interpret a multi-dimensional bubble chart in Google Sheets. It's a powerful way to represent complex datasets visually, and by using tools like ChatGPT, you can streamline the process from generating ideas and data structures to extracting key insights.

While creating charts in tools like Google Sheets is useful, it can be extremely manual and time-consuming, especially if you're trying to centralize various platforms and tools around a single-pane-of-glass dashboard view. At Graphed, we built out our platform to give you all of your time back, allowing you to invest in other growth ventures or strategic decisions around the reports themselves, so let us focus on what's best - helping you do your job more efficiently.