Excel.Series.Values.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Series.Values property (Excel)	vbaxl10.chm578111	vbaxl10.chm578111	Excel.Series.Values	3db2577e-ef0e-75ea-412b-531d7e67c098	05/11/2019	medium

Series.Values property (Excel)

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

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.

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)

[!includeSupport and feedback]