DATA.SERIES

Macro Sheets Only

Equivalent to choosing the Series command from the Fill submenu on 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

List of Command-Equivalent Functions