Arrow
Back to guides
Google Sheets Tips

How to Make a Bubble Chart in Google Sheets

In this article, you will learn how to create a bubble chart in Google Sheets. 

What is a bubble chart in Google Sheets?

A bubble chart is effective when you want to compare your data with that of your competitors from three aspects, one of which should be the size/amount to be reflected as a size of a babble (or pie) in the chart. For example, you can use a bubble chart to show your company’s position in the market, focusing on revenue size, revenue growth, and operating margin, shown as bubble size, x-axis, and y-axis, respectively.

How to create a bubble chart in Google Sheets

  1. Prepare a data set including four elements for series name, x-axis, y-axis, and bubble size and select it
  2. Go to “Insert” and click ”Chart” or navigate to the “Insert chart” icon directly.
  3. Then, you have a default chart on a sheet, and a chart editor shows up on the right.
  4. Select “Bubble chart” in the “Scatter chart” section.
  5. Assing proper items to each of the four fields - “X-axis”, “Y-axis”, “Series”, and “Size”
  6. Move to the “Customize” tab in the chart editor and customize your chart if you want.
insert a bubble chart from the menu bar
How to insert a bubble chart from the menu bar in Google Sheets

Learn how to make a bubble chart by looking at an example. Assume you have the following data set including revenues, revenue growths, and operating margins of five companies and you want to make the following chart from the data set.

sample bubble chart 
A sample bubble chart with a sample data set

These are the steps you need to take to create the bubble chart shown above.

  1. Ensure the right range is selected and assign each element of the data set to a proper category in the “Set up” tab, Revenue Growth in “X-axis”, Operating Margin in “Y-axis”, Company in “Series”, and Revenue in “Size”.
  2. Change “Font”, and remove “Chart border color” in the “Chart style” section.
  3. In the “Bubble” section, change “Opacity” to 100%.
  4. In the “Chart and axis titles”, modify the chart title and put proper axis names for the x-axis and y-axis, and make them bold.
  5. Change the location of the legend in the “Legend” section.
  6. Input the x-axis range in the “Horizontal axis” section.
  7. Enter the maximum and minimum value for the vertical axis in the “Vertical axis” section.

A tip: If you want to change the colors of bubbles, go to the “Series” section in the “Customize” tab.

Allocate each piece of information
Step 1: Allocate each piece of information to data categories properly

Increase the opacity of the bubble 
Step 2: Change font and chart border color in the Chart style tab

Change font and chart border color
Step 3: Increase the opacity of the bubble to 100% in the Bubble tab

Rename chart and axis titles and
Step 4: Rename chart and axis titles and make them bold

Change the position of the legend
Step 5: Change the position of the legend

Adjust the maximum and minimum value for the x-axis 
Step 6: Adjust the maximum and minimum value for the x-axis in the Horizontal axis section

Modify the y-axis range 
Step 7: Modify the y-axis range in the Vertical axis section

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below