Series.Values Property (Word)
Returns or sets a collection of all the values in the series. Read/write Variant.
Version Information
Version Added: Word 2007
Syntax
expression .Values
expression A variable that represents a Series object.
Remarks
The value of this property can be either the address of a range on the chart's worksheet or an array of constant values, but not a combination of both. See the examples for details.
Example
The following example sets the series values from a range address.
With ActiveDocument.InlineShapes(1)
If .HasChart Then
.Chart.SeriesCollection(1).Values = "=Sheet1!B2:B5"
End If
End With
To assign a constant value to each individual data point, you must use an array, as shown in the following example.
With ActiveDocument.InlineShapes(1)
If .HasChart Then
.Chart.SeriesCollection(1).Values = _
Array(1, 3, 5, 7, 11, 13, 17, 19)
End If
End With