How to Create a Bubble Chart in Google Sheets

Representing data in a visual form is an essential and useful technique as it makes it simpler to display, analyze, and compare. One of the best ways of presenting data into a visual form is the Bubble Chart. A bubble chart is a set of different disk-shaped diagrams on a graph/plot. It is commonly used to exhibit multiple sets of large data with three or more dimensions.

While there are many ways to create bubble charts online, an easy tool is Google Sheets. Let’s see how you can do that!

How would you like to create your Bubble Chart?

How to Create a Bubble Chart in Google Sheets

To learn how to create a bubble chart online using Google Sheets, follow this basic tutorial.

Step 1 – Open Goggle Sheets

Firstly, open Google Sheets on your browser and log in using your Google account. Then select a blank sheet.

Step 2 – Enter Data

To make a bubble chart, enter the data by manually typing it, or you can copy & paste from a desktop document. You can also import your data by going to File Tab and then clicking on the import option. For this tutorial, we will use a manually entered sample data.

google enter data

Step 3 – Insert Chart

Now select the data and click on the Insert Tab. Please scroll down to the Charts option and click on it. Google Sheet will insert a bar chart by default.    

google insert chart

Step 4 – Insert Bubble Chart Google Sheets

To change the bar graphs to Google bubble chart, double click on the chart. A chart editor will appear on the right side of the screen. Now, go to the Set-up tab and click on the drop-down arrow of Chart Type. Scroll down to Scatter Chart and select the second option called Bubble. Google Sheets will change the bar chart into the Google bubble chart.

google bubble chart

Step 5 – Customize your Bubble Chart Google sheets

Go to Customize under Chart Editor and select different edit and format options to change your bubble chart. You can change the font, size, color, and other aspects of the bubble chart. Once you are satisfied with the final look of your Bubble chart, close the Chart Editor, and save your sheet.

google customize chart

In this way, you can create a simple and basic Bubble Chart on Google Sheets in just five easy steps.

How to Create a Bubble Chart in Edraw Max

Edraw Max Online is another great tool to make a bubble chart. This online diagram software comes with many free templates and tools to create different types of visual content. Go to https://www.edrawmax.com/online/ right now and create a bubble chart online for free.

Follow these instructions to make a bubble sheet in Edraw Max Online.

Step 1 – Launch Edraw Max Online

Launch Edraw Max Online on your browser and select New to scroll through different options.

edrawmax bubble chart

Step 2 – Select Bubble Chart

Go to Graphs and Charts and select Bubble Chart. You can use a blank page to create your chart or use a free online template by Edraw. We will use a blank page to create a bubble chart from scratch. Click on the big “+” icon to launch the editor in your browser.

Step 3 – Insert Bubble Chart

Now go to Insert Tab and click on Charts. The Insert a Chart window will appear on your screen. Scroll down to Scatter Chart and select the second option, i.e., Bubble Chart. Now press OK to insert a bubble chart. A bubble chart will be added on your Edraw page.

edrawmax insert chart

Step 4 – Adjust Chart and Enter Data

Now edit and format your Bubble Chart according to your preferences, and once you are satisfied with the result, close the formatting pane. Finally, save your bubble chart document.

edrawmax enter data

Step 5 – Customize your Bubble Chart

Now edit and format your Bubble Chart according to your preferences and once you are satisfied with the result, close the format. Finally, save your bubble chart document.

edrawmax customize chart

How to Save an Edraw Chart as a Common File

Edraw Max Online lets you export Edraw documents in many different commonly-used software types. To save an Edraw file in another software, click on File and go to Export option. A side menu will appear with various options such as Graphics, PowerPoint, PDF, and more. Now, select the software where you want to save your chart.

edrawmax export

To save Edraw documents in Google Drive and Dropbox, click on File and then Save as. A pop-up window will appear where you can save your Edraw Bubble chart in Dropbox or Google Drive. Select the desired location and click on OK.

Our step-by-step guide on how to create a bubble chart in Google Sheets and Edraw Max Online concludes here.

Related Articles