Edit

Series.XValues property (Excel)

  • Article

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.

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 on Chart1 to the range B1:B5 on Sheet1.

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 on Chart1.

Charts("Chart1").SeriesCollection(1).XValues = _ 
 Array(5.0, 6.3, 12.6, 28, 50)

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.