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.

Click "Move Chart" at the far right of the Chart Tools section. Click "New Sheet" and enter the name for your new sheet in the field provided. Click "OK" to move the chart to a new sheet.

In Excel 2003, choose Chart from the Insert menu. We won’t actually use this graph, but it’s wise to create a default chart so you can see how well the chart window will accommodate the data.

Gantt charts are one of my favorite ways to gain visual project overviews. Whether you use Google Sheets or Excel, you can enjoy using several beginner-friendly templates for work, studying, and ...