To show the equation of the line (y=mx +b), check the 'Show Equation' box. If the plot is to go thru the origin, check the 'Set Intercept' box, and enter 0 in the box. Don’t forget the units! (Use rotated on the vertical axis.) Also, select Chart Title to add a title for the entire chart. Click on Axis Titles in the Labels submenu. If X and Y are backwards, re-select the values on this window.) For example, on a density plot the mass should be on the Y-axis, and volume on the X-axis. (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. Select the first option, scatter with only markers. (Click in a corner and drag the mouse until all boxes are selected.
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
