Applies To
Series Object.
Description
Returns or sets an array of x values for a chart series. The XValues property can be set to a range on a worksheet or an array of values, but it may not be a combination of both. Read-write.
Example
This example sets the x values for series one in Chart1 to the range B1:B5 on Sheet1.
Set Charts("Chart1").SeriesCollection(1).XValues = _ Worksheets("Sheet1").Range("B1:B5")
This example uses an array to set values for the individual points in series one in Chart1.
Charts("Chart1").SeriesCollection(1).XValues = _ Array(5.0, 6.3, 12.6, 28, 50)