This article will explain How to Create a Quadrant Chart in Google Sheets.
A quadrant chart is a particular kind of graph that enables you to see the points on a scatter plot as belonging to four different quadrants.
How to Create a Quadrant Chart in Google Sheets : Step By Step Guide
Enclosed are the steps to Create a Quadrant Chart in Google Sheets
Step 1 : Open Google Sheet and prepare yout data set
As a first step we will need a data set for which we can create a Quadrant Chart
You can create an arrange your dataset in X-axis and Y-axis as shown below .
![How to Create a Quadrant Chart in Google Sheets](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-FfP9l14Z/w:323/h:254/q:auto/https://addnewskills.com/wp-content/uploads/2022/09/image-174.png)
Step 2 : Insert a Scatter Plot Graph
- Select any cell within the data set and press CTRL+A to select the entire dataset .
- Now Click on the Insert menu and Select Chart from the drop-down
Insert->Chart
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-D4Xv0SGZ/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/09/image-176.png)
Step 3 : Change the Chart type
Once you click on Insert->Chart .A Chart editor screen will pop-up on the right side of your Google Sheets..
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-5sPS6QxE/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/09/image-178.png)
Google Sheet will automatically insert a default Line Chart for the Select data set as shown below.
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-Xb8-UNFv/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/09/image-177.png)
- Click on the down arrow in front of Line Chart under Chart type
- Now scroll down and Select Scatter Chart from the suggested Charts
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-v_K_GF8z/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/09/image-179.png)
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-vkkRkmtW/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/09/image-180.png)
Step 4 : Customize to create a Quadrant Chart.
In the Scatter plot the X-axis range from -6 to 4 and Y-axis range from -10 to -10.But the Required Quadrant chart requires both the axis to have the same range.
- To edit the range for X-axis Click on the Customize tab on the Chart editor.
- Now Scroll down and expand horizontal axis and change the Min and Max values to -10 and 10.
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-AOdskEvR/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/09/image-182.png)
Now both the X-axis and Y-axis will have the same range .
![](https://ml6efdvut7qo.i.optimole.com/Sjge_4I-kom_F2Gr/w:auto/h:auto/q:auto/https://addnewskills.com/wp-content/uploads/2022/09/image-183.png)
How to Create a Quadrant Chart in Google Sheets(Conclusion)
In the above tutorial we have shown you a step by step guide using which you can create a Quadrant Chart in Google Sheets.
We hope this tutorial on How to Create a Quadrant 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 )