(If you put Y as column A and X as column B, this will be done automatically. Make sure the proper X and Y values are selected. Click on Series1 (on the left) if it is not already selected, and press the Edit button just above it. Right click on the graph, and select Select Data.Select the first option, scatter with only markers. (Click in a corner and drag the mouse until all boxes are selected. Set the data range by selecting all the data.To show a linear relationship using Excel, such as density, complete the following steps: How to Make a Linear Plot using Microsoft Excel 2010 To Make a Linear Plot using Microsoft Excel
