Series.Values Property

Syntax

expression.Values

expression A variable that represents a Series object.

Remarks

The value of this property can be a range on a worksheet or an array of constant values, but not a combination of both. See the examples for details.

Example

This example sets the series values from a range.

Visual Basic for Applications
`Charts("Chart1").SeriesCollection(1).Values = _ Worksheets("Sheet1").Range("C5:T5")`

To assign a constant value to each individual data point, you must use an array.

Visual Basic for Applications
`Charts("Chart1").SeriesCollection(1).Values = _ Array(1, 3, 5, 7, 11, 13, 17, 19)`

Returns or sets a Variant value that represents a collection of all the values in the series.