Values Property 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)