Series.XValues property (Excel)
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.
expression A variable that represents a Series object.
For PivotChart reports, this property is read-only.
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.