We can chart a regression in Excel by highlighting the data and charting it as a scatter plot. To add a regression line, choose "Add Chart Element" from the "Chart Design" menu.

Excel stops copying the formula when it reaches the last cell with adjacent data. Enter "=Average (C:C)-2.66*Average (A:A)" in cell D2 and copy the formula down the column to create the lower limit.