Struggling to Create a Four Quadrant Chart in Excel?

QI Macros Can Do It For You!

Draw a 4 Quadrant Graph using QI Macros

  1. Select your data.
  2. Select Box, Dot & Scatter > Quadrant Scatter on QI Macros menu.
  3. QI Macros will do the math and draw the graph for you.

Quadrant & scatter charts compare the relationship between two variables

The difference is the placement of the Y axis in relationship to the X axis.
Both of these charts are easy to create using QI Macros add-in for Excel.

Scatter Diagram

scatter plot excel

Quadrant Graph

quadrant graph

To create a Quadrant Chart using QI Macros add-in

Highlight your two-columns of data

quadrant-scatter-data

Then, select "Box, Dot & Scatter Plot" > Quadrant Scatter

quadrant-scatter-menu

Next, you will be asked to input the point at which the Y-Axis crosses the X-Axis and the X-Axis Crosses the Y-Axis - this creates your quadrant. Note that we also identify potential crossings for you:

quadrant-scatter-axis-prompt

quadrant-scatter-axis-prompt

A four Quadrant Chart will then be created:

quadrant-graph-chart


You can also manually convert a scatter plot to a four-quadrant graph

  1. First, delete the trend line from your scatter diagram.

    scatter plot with no trend line
  2. Second, reformat your X-Axis.

    Right click on the X-axis, select Format Axis

    right click on x axis
    Now change the value where you want the vertical Y-axis to cross the X-axis. In this example, we chose 45.

    scatter-diagram-axis-value
  3. Third, reformat your Y-Axis.

    Right click on the Y-axis, select Format Axis

    right click on x axis
    Now change the value where you want the horizontal X-axis to cross the Y-axis. In this example, we chose 50.

    scatter-diagram-axis-value

  4. Once you have updated both the X and Y Axis Values, you should have a XY Scatter Diagram with Four Quadrants!

    quadrant graph

QI Macros contains a Quadrant chart template too!


Stop Struggling with Quadrant Scatter Charts!
Start creating your Quadrant Scatter Charts in just minutes.

Download a free 30-day trial. Get Quadrant Scatter Charts now!

Other Charts Included in QI Macros Excel add-in