Values Property
Applies To
Scenario object, Series object.
Description
Scenario object: Returns an array that contains the current values of the changing cells for the scenario. Read-only Variant.
Series object: Returns or sets a collection of all the values in the series. This can be a range on a worksheet or an array of constant values, but not a combination of both. See the examples for details. Read/write Variant.
Example
This example sets the series values from a range.
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.
Charts("Chart1").SeriesCollection(1).Values = _
Array(1, 3, 5, 7, 11, 13, 17, 19)