How to Generate a Quadrant Chart

Image of a woman working on a laptop.
Image Credit: BartekSzewczyk/iStock/Getty Images

A quadrant chart centers the horizontal "X" axis and the vertical "Y" axis in the center of a graph. This placement divides the chart into four quadrants, in which negative and positive data values are plotted. Most spreadsheet programs such as Microsoft Excel, OpenOffice Calc and LibreOffice Calc create quadrant charts using the Scatter chart selection. Changing the minimum and maximum values for each axis in the scatter chart produces uniform quadrants for the data plots.

Microsoft Excel

Step 1

Enter the X-axis data in column A. Enter the corresponding Y-axis data down column B. As an example, you might enter X and Y geometric coordinates in columns A and B.

Step 2

Click and drag your mouse to highlight all the data you entered.

Step 3

Click the "Insert" tab. Click "Scatter" from the Charts group and select the first "Scatter with only Markers" option.

Step 4

Click the "Layout" tab. Click "Axes" from the Axes group, point to "Primary Horizontal Axis" and select "More Primary Horizontal Axis Options."

Step 5

Select "Fixed" from the Minimum and Maximum options on the Axis Options tab. Enter equivalent negative and positive values in each field. Make sure your range is large enough to accommodate each data point. As an example, if the lowest data value is negative 10 and the highest value is 10, you would enter "-10" and "10" for the minimum and maximum values. By default, axis labels appear next to the axis. To place labels at the bottom of the chart, select "Low" from the Axis Labels drop-down menu.

Step 6

Click "Line Color" from the left pane. Click "Solid Color" from the right pane. Select your preferred color, such as solid black, from the Color drop-down menu. Doing this makes the middle axis more recognizable. Click "Close."

Step 7

Click "Axes" again. Point to "Primary Vertical Axis" and select "More Primary Vertical Axis Options."

Step 8

Enter the same minimum and maximum values you entered previously for the horizontal axis. In the example, you would enter "-10" and "10" for the minimum and maximum values. Select "Low" from the Axis Labels drop-down menu to move the axis labels to the left.

Step 9

Click "Line Color" from the left pane. Click "Solid Line" and select the same color you previously selected. Click "Close" to complete your quadrant chart.

OpenOffice Calc and LibreOffice Calc

Step 1

Click and drag your mouse to highlight the X-axis and Y-axis data.

Step 2

Click "Insert" in the top menu and select "Chart."

Step 3

Click "XY (Scatter)" from the "Choose a Chart Type" section. The "Points Only" option is already selected by default. Click "Finish."

Step 4

Click "Format," "Axis" and "X-Axis." Click the "Scale" tab. Uncheck "Automatic" from the Minimum and Maximum options. Enter minimum and maximum range values for the quadrant chart.

Step 5

Click the "Line" tab. Click the "Color" drop-down menu and select a prominent color, such as black, to use for the center line.

Step 6

Click the "Positioning" tab. Click the "Place Labels" drop-down menu and select "Outside Start." Doing so places the axis labels at the bottom of the chart. Click "OK."

Step 7

Click "Format," "Axis" and "Y Axis." Enter the minimum and maximum range, line color and label position, exactly as you did for the X-Axis. Click "OK" to complete your quadrant chart.

references