How do I add a regression line (or “line of best fit”) in a scatter chart?

  1. In the Regression analysis, make sure you have selected to output the dependent and the explanatory series
  2. Add a Scatter chart from the Regression analysis
  3. Go the Scatter chart and open the Graph layout menu
  4. In graph layout, you need to set two pairs of lines

a) Pair #1: the explanatory and the dependent series

b) Pair #2: the explanatory and the predicted series

Example file: Regression line