How to Make a Chart on Excel With Coordinates

1. Open a new Microsoft Excel 2010 spreadsheet.
2. Click on cell 'A1' and type in the header for the first half of your set of coordinates. This header will not appear on the spreadsheet, but may be of use for referencing purposes when you are entering your data. Click on cell 'B1' and type in the header for the second half of your set of coordinates. This header will wind up as the title for your chart, and will be displayed in the chart's legend as well.
3. Select cell 'A2' and enter the first part of your first set of coordinates. This part of your coordinates will be plotted on the horizontal axis. Select cell 'B2' and end the second part of that set of coordinates. This part of the coordinates will be plotted on the vertical axis. Continue to enter in sets of coordinates in the first two columns until you have added all your data to the spreadsheet.
4. Click on cell 'B1' and select the 'Insert' tab at the top of the screen. Click the 'Scatter' button, located in the Charts area of the ribbon. Choose any of the five different XY Scatter charts that appear in the pop-up menu. The different charts will all plot the same data, but will allow you to choose to add curvy lines, straight lines and data markers. Once you click on your desired chart type, the chart will appear on your spreadsheet.