Arrow left
Back to product 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.
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.

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.

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

Step 2: Change font and chart border color in the Chart style tab

Step 3: Increase the opacity of the bubble to 100% in the Bubble tab

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

Step 5: Change the position of the legend

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

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

How do you make other types of graphs?

It is easy. After inserting a graph, select another chart pattern in the “Chart” type section. You can learn how to create other basic charts in the following articles.

How to Make a Column Chart in Google Sheets

How to Create a Pie Chart in Google Sheets

How to Make a Waterfall Chart in Google Sheets

How to Make a Line Chart in Google Sheets

How to Make a Stacked Column Chart in Google Sheets

Are you interested in creating a customized KPI dashboard reflecting your data in real time? Check LiveFlow and the following template with graphs.

Here is an example of how charts are utilized for data sharing and reporting.

You can learn about other Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides

Analyze your live financial data in a snap

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows and update numbers in real-time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

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

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:
Check Icon
Call us at +1 (415) 650-1711