Equivalent to clicking the Series command on the Fill submenu of the Edit menu. Use DATA.SERIES to enter an interpolated or incrementally increasing or decreasing series of numbers or dates on a sheet or macro sheet.
Syntax
DATA.SERIES(rowcol, type_num, date_num, step_value, stop_value, trend)
DATA.SERIES?(rowcol, type_num, date_num, step_value, stop_value, trend)
Rowcol is a number that specifies where the series should be entered. If rowcol is omitted, the default value is based on the size and shape of the current selection.
| Rowcol | Enter series in |
| 1 | Rows |
| 2 | Columns |
Type_num is a number from 1 to 4 that specifies the type of series.
| Type_num | Type of series |
| 1 or omitted | Linear |
| 2 | Growth |
| 3 | Date |
| 4 | AutoFill |
Date_num is a number from 1 to 4 that specifies the date unit of the series, as shown in the following table. To use the date_num argument, the type_num argument must be 3.
| Date_num | Date unit |
| 1 or omitted | Day |
| 2 | Weekday |
| 3 | Month |
| 4 | Year |
Step_value is a number that specifies the step value for the series. If step_value is omitted, it is assumed to be 1.
Stop_value is a number that specifies the stop value for the series. If stop_value is omitted, DATA.SERIES continues filling the series until the end of the selected range.
Trend is a logical value corresponding to the Trend check box. If trend is TRUE, Microsoft Excel generates a linear or exponential trend; if FALSE or omitted, Microsoft Excel generates a standard data series.
Remarks
If you specify a positive value for stop_value that is lower than the value in the active cell of the selection, DATA.SERIES takes no action.
If type_num is 4 (AutoFill), Microsoft Excel performs an AutoFill operation just as if you had filled the selection by dragging the fill selection handle or had used the FILL.AUTO macro function.
Related Function
FILL.AUTO Copies cells or automatically fills a selection
Return to index