Series.Values (Excel)

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

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.

Charts("Chart1").SeriesCollection(1).Values = _ 
 Worksheets("Sheet1").Range("C5:T5")