XlDataSeriesType Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Specifies the data series to create.

Name

Value

Description

xlAutoFill

4

Fill series according to AutoFill settings.

xlChronological

3

Fill with date values.

xlDataSeriesLinear

-4132

Extend values, assuming an additive progression (for example, '1, 2' is extended as '3, 4, 5').

xlGrowth

2

Extend values, assuming a multiplicative progression (for example, '1, 2' is extended as '4, 8, 16').

Show: