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.

For example, let’s say you have two charts on two different worksheets, and you want to put them both on a single chart sheet for comparison and printing. Follow these steps: Click ...

Headers and Footers for Charts Excel charts can also have their own headers and footers. Editing them isn't too different from editing the headers and footers on ordinary sheets.