Range.DataSeries Method

Creates a data series in the specified range.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function DataSeries ( _
    Rowcol As Object, _
    Type As XlDataSeriesType, _
    Date As XlDataSeriesDate, _
    Step As Object, _
    Stop As Object, _
    Trend As Object _
) As Object
'Usage
Dim instance As Range
Dim Rowcol As Object
Dim Type As XlDataSeriesType
Dim Date As XlDataSeriesDate
Dim Step As Object
Dim Stop As Object
Dim Trend As Object
Dim returnValue As Object

returnValue = instance.DataSeries(Rowcol, _
    Type, Date, Step, Stop, Trend)

Object DataSeries(
    Object Rowcol,
    XlDataSeriesType Type,
    XlDataSeriesDate Date,
    Object Step,
    Object Stop,
    Object Trend
)

Parameters

• Rowcol
  Type: System.Object

  Optional Object. Can be the xlRows or xlColumns constant to have the data series entered in rows or columns, respectively. If this argument is omitted, the size and shape of the range is used.

• Type
  Type: Microsoft.Office.Interop.Excel.XlDataSeriesType

  Optional XlDataSeriesType. Can be one of the following XlDataSeriesType constants:

  • xlAutoFill

  • xlDataSeriesLineardefault

  • xlChronological

  • xlGrowth

• Date
  Type: Microsoft.Office.Interop.Excel.XlDataSeriesDate

  Optional XlDataSeriesDate. If the Type argument is xlChronological, the Date argument indicates the step date unit. Can be one of the following XlDataSeriesDate constants:

  • xlDaydefault

  • xlWeekday

  • xlMonth

  • xlYear

• Step
  Type: System.Object

  Optional Object. The step value for the series. The default value is 1.

• Stop
  Type: System.Object

  Optional Object. The stop value for the series. If this argument is omitted, Microsoft Excel fills to the end of the range.

• Trend
  Type: System.Object

  Optional Object. True to create a linear trend or growth trend; False to create a standard data series. The default value is False.

Return Value

Type: System.Object

See Also

Reference

Range Interface

Range Members

Microsoft.Office.Interop.Excel Namespace