- In the Regression analysis, make sure you have selected to output the dependent and the explanatory series
- Add a Scatter chart from the Regression analysis
- Go the Scatter chart and open the Graph layout menu
- 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