How to Graph Two Datas Scatter Plot in Excel

1. Open the Excel spreadsheet containing the two columns of data you want to turn into a scatter plot. Scroll down to the bottom of the column and click the lowest cell containing the data. Drag up and across until both columns are highlighted.
2. Navigate to the 'Insert' tab at the top of the spreadsheet, which is positioned to the left of the 'Home' tab. Click the 'Scatter' button in the 'Charts' heading near the top of the screen.
3. Click the icon in the drop-down menu for the specific type of scatter plot you want to use, such as 'Scatter With Only Markers,' 'Scatter With Smooth Lines and Markers' or 'Scatter With Straight Lines.'
4. Click the scatter plot and drag it to any location on the spreadsheet. Click either of the plot's four corners and drag in any direction to resize the plot, making it larger or smaller to fit into any collection of cells.