Home » Knowledge Base » Scatter Plot » Quadrant Graph

Quadrant Graph in Excel

How to Convert a Scatter Plot to a Four Quadrant Graph

Step by Step Example to Change a Scatter Plot to a Quadrant Graph

1. First, delete the trend line from your scatter diagram.
   
   
2. Second, reformat your X-Axis.
   
   
   Right click on the X-axis, select Format Axis
   
   

   Now change the value where you want the vertical Y-axis to cross the X-axis. In this example, we chose 45.
   
   
3. Third, reformat your Y-Axis.
   
   
   Right click on the Y-axis, select Format Axis
   
   

   Now change the value where you want the horizontal X-axis to cross the Y-axis. In this example, we chose 50.
   
   
   
   
4. Once you have updated both the X and Y Axis Values, you should have a XY Scatter Diagram with Four Quadrants!
   
   

Learn More...

• Scatter Diagram Examples
• Scatter Plot Matrix for more than two variables

To create a Quadrant Graph Excel using QI Macros...