How to Make a Coordinate Plane in MS Excel

Making a coordinate plane can help you present data for your research reports.
••• Image Source/Stockbyte/Getty Images

A coordinate plane is formed by two lines that intersect at right angles, creating four sections called quadrants. Coordinate planes are used to graph ordered pairs and equations or to construct scatter plots. You can make a coordinate plane in Microsoft Excel, using cell formatting and drawing tools.

    Open a new, blank Excel document. Click the "Rectangle" in the upper-left corner of the spreadsheet located at the intersection of column A and row 1. This will select the entire spreadsheet. Click the "View" tab. In the Show/Hide group, deselect "Gridlines."

    Place your cursor on a line between any two column headers. Your cursor will change to a vertical line crossed by a horizontal arrow. Drag the line left until the column width is exactly 20 pixels. When you release the mouse, all cells will be square. Click in cell "A1" to remove the highlighting.

    Click cell "C3" and drag and highlight the 400-cell area to cell V22. In the Font group on the Home tab, click the "Arrow" on the border tool. Select the "Border" that resembles a window with four panes.

    Click the "Insert" tab. In the Illustrations group, click the arrow on "Shapes." Select the line with two arrow heads.

    Draw the x-axis between row 12 and row 13. To make a straight line, hold the "Shift" key while you click and drag. Draw the y-axis between columns L and M.

Related Articles

How to Create Matrices on a TI-89
How to Remove Duplicates in Two Rows in OpenOffice
How to Calculate Correlation Coefficient Between Two...
How to Make a Monthly Budget Circle Graph
How to Find Correlation Coefficient & Coefficient of...
How to Create a Normal Distribution Graph in Excel
How to Graph a Distribution for a T-Test
How to Plot Line Segments on Graphing Calculator
How to Subtract Matrices on Excel
How to Make a Model of a Cell With Playdough
How to Draw a Normal Distribution in Excel
How to Find the Slope of a Plotted Line With the TI-84...
What Does ##### Mean in Excel?
How to Solve 3-Variable Linear Equations on a TI-84
How to Calculate Slope Using the TI-83 Plus
How to Use the Trapezoidal Rule in Microsoft Excel
How to Make a Cell Model Styrofoam Ball
How to Build a Model of a Human Cell
How to Draw Pictures on a Graphing Calculator
Plant & Animal Cell Activities for Fourth Grade

Dont Go!

We Have More Great Sciencing Articles!