In this tutorial, you will learn How To Make Bubble Chart In Google Sheets.
Bubble Chart Google Sheets
To make Bubble Chart In Google Sheets, Select the data series for which you want to create a Bubble chart then Go to Insert ->Chart. Now Go to Chart type and Change the default chart type to Bubble Chart from the drop-down option under.
How To Make Bubble Chart In Google Sheets: Step by Step Guide
Enclosed are the steps to How To Make Bubble Chart In Google Sheets
Step 1: Open Google Sheets
As a first step, you need to open google sheets with an existing group of datasets or create a new google Sheets with the required dataset.
You will need at least two sets of data series.
In this example, we will use the below data set.
Step 2: Choose the complete dataset
To select the entire dataset, click on any of the cells and press CTRL+A
Step 3 : Go to Insert->Chart
Once the dataset is selected click on the Insert menu in the main menu bar and Select Chart from the drop-down.
Once you click on the Chart option. A Chart editor screen will pop up on the right side of your Google Sheet.
By default, Google Sheets will generate a Column Chart for the Selected dataset.
Step 4 : Change the default Chart type
Under Chart, type click on the down arrow beside the Column Chart.
Now scroll down and Select Bubble Chart under the option under Scatter
A bubble Chart will be created and displayed beside your dataset as shown below.
Step 5 :
Customize the Chart as per your need
Bubble Chart will be displayed beside the data series. Now You can drag the Chart to adjust its position.
You can perform further customization to change the chart style such as chart background color or border color etc. as per your requirement.
How Do I Make a Bubble Chart in Google Sheets?
To make Bubble Chart In Google Sheets, Select the data series for which you want to create a Bubble chart then Go to Insert ->Chart. A default Column Chart will be automatically inserted for the selected dataset .
Now Go to Chart type and Click on the down arrow to get various chart options. Scroll down and chart type to Bubble Chart from the drop-down option under Scatter.
How Do You Make a Bubble Chart With 3 Variables?
To create a Bubble Chart with 3 variables you need to arrange your data in the below format
Column A – Label
Column B – Value for X-axis
Column C – Value for Y-axis
Column D – Color
Column E – Size
Now choose the dataset and Click on Insert>Chart.
Now on the Chart Editor under Chart Style Change the default chart to Bubble chart from the drop-down options
How To Make Bubble Chart In Google Sheets(Conclusion)
In this tutorial, we have shown you a step-by-step guide to quickly create a Bubble chart for a data series.
We hope this tutorial on How To Make Bubble Chart In Google Sheets was useful.
Related articles:
How to Insert Spin Button in Google Sheets ( Easy Guide )
How to Freeze Rows in Google Sheets
How to Calculate Square Root and Cube Root in Google Sheets(Quick & Easy Guide)
How to use SUMSQ Function in Google Sheets(Quick & Easy Guide )
