How to Plot Points on a Grid

1. Open Excel or another spreadsheet. Enter headers in cells A1 and B1 that correspond to your variables. For example, if you want to plot age against income, put 'Age' in cell A1 and 'Income' in cell B1. The A column will correspond to the X axis and the B column to the Y axis. (You can enter the data in any cells; just be consistent.)
2. Enter the appropriate data. In our example, enter the data for age and income in the appropriate columns, starting in row 2 and continuing with one row per person.
3. Plot the data. In a new cell, click 'Insert,' 'Scatter' and then click on the graph in the upper left of the panel of graphs.
4. Modify the plot. In the Charts Layout section, scroll down with the arrows until you get to layout 10, and click on it.
5. Modify the axes. Inside the graph, click on 'Axis title' on the horizontal axis and enter 'Age.' Then click on 'Axis title' on the vertical axis and enter 'Income.'