Tandaan
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang mag-sign in o baguhin ang mga direktoryo.
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang baguhin ang mga direktoryo.
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.