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.
This example sets the x values for series one in Chart1 to the range B1:B5 on Sheet1.
This example uses an array to set values for the individual points in series one in Chart1.