| **Series in** - Decides whether the series is to be filled across the page (across the selected columns) or down the page (across the selected rows).
| |

| **Trend** - Calculates a best-fit line (for linear series) or geometric curve (for growth series). The step values for the trend are calculated from the existing values at the top or left of the selection. Any value in the Step value box is ignored if the Trend check box is selected. Excel will calculate the average change between the values already entered and uses that information to calculate a series to populate the remaining cells.
| |

| **Step Value** - Enter a positive or negative number to indicate the amount by which you want a series to increase or decrease. The default value for any series is 1.
| |

| **Stop Value** - Enter a positive or negative number to indicate the value at which you want the series to end. If the selection is filled before the series reaches the stop value, the series stops at that point. If the selection is larger than needed to fill the series, the remaining cells of the selection are left blank. You do not need a value in the Stop value box to fill a series.
| |