How to Make a Coordinate Plane in MS Excel

Updated July 19, 2017

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.

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Based in Houston, Jennifer Neel has been writing education-related articles since 2010. She is a Texas-certified mathematics teacher. She holds a Bachelor of Business Administration in finance and marketing from the University of Houston and is pursuing a Master of Education in instructional leadership from American Public University.