How to Make a Grid Chart

by Anthony Bonesarelli ; Updated July 27, 2017
A grid chart can be a useful canvas for plotting any kind of data.

Items you will need

  • Pencil
  • Ruler
  • Graph paper
  • Microsoft Excel

A uniformly spaced plane like a grid chart makes studying and observing a selection of data much easier. With a clean chart and meticulous plotting on a grid chart, the user can easily see trends over time or among different sets. Grid charts work for a number of other purposes as well, such as a mailing list that features a neatly organized list of names and addresses. You can either make a paper grid chart yourself or use data entry or spreadsheet software to customize a digital grid chart.

Make a Grid Chart on Paper

Step 1

Draw a large, thin "L" on the lines on a sheet of graph paper, using a ruler as a straightedge to keep your lines even. Use most of the page but leave a margin to note the sets for the X- and Y-axes of your chart.

Step 2

Write the values for your X- and Y-axes in the margins of the paper. For example, if you were charting how much money you spent over the course of a year, beneath the horizontal line indicating your X-axis, you would write "Months" or "Time." To the left of your (vertical) Y-axis, you would write "Money Spent."

Step 3

Draw marks at regular intervals on each axis to indicate the progression of each value. Label each of these with a value or other set. To continue the above example, you could make marks every five intervals on the graph paper for both axes. The vertical marks could represent dollars in $100 increments, while the horizontal axis could be marked by months of the year.

Make a Grid Chart in Microsoft Excel

Step 1

Open Microsoft Excel and select "New Spreadsheet" when prompted. A default template spreadsheet will appear in the Excel window.

Step 2

Click the "Format" menu in the upper toolbar. You can customize your grid chart by clicking "Cells." This option opens a menu which enables you to adjust the number of cells in each row and column.

Step 3

Click "Column" or "Row" in the "Format" menu to edit the particular size of each row and column. The column width can vary between 0 and 255 units, while the row height can be set between 0 and 409 units.

Step 4

Enter your data into each row and column. Excel will automatically maintain the straight lines of your grid chart. If you find that the boxes are too small for your data, return to Step 2 and readjust the row or column size.

Tips

  • Use the X-axis of a paper grid chart as your "Time" value. It is generally easier to understand data plotted over time in a horizontal fashion.

About the Author

Anthony Bonesarelli began writing as a columnist for "The Daily Athenaeum" university publication in 2006. He now specializes in music criticism online at Garbage Days and social media consulting at a West Virginia art gallery. He graduated from West Virginia University in 2010 with a Bachelor of Arts in English.

Photo Credits

  • Aaron Graubart/Digital Vision/Getty Images