Series.XValues Property

Syntax

expression.XValues

expression A variable that represents a Series object.

Remarks

For PivotChart reports, this property is read-only.

Example

This example sets the x values for series one in Chart1 to the range B1:B5 on Sheet1.

Visual Basic for Applications
`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.

Visual Basic for Applications
`Charts("Chart1").SeriesCollection(1).XValues = _ Array(5.0, 6.3, 12.6, 28, 50)`

Assign x values of a series to a particular column? Find the x values on a particular series? Give a list of values as x variables of series? x values X Values Property xvalues Xvalues property

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 to an array of values, but it cannot be a combination of both. Read/write Variant.

See also: