XlDataSeriesType enumeration (Excel)

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').

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.