Skip to content

Latest commit

 

History

History
50 lines (30 loc) · 1.11 KB

Excel.Series.XValues.md

File metadata and controls

50 lines (30 loc) · 1.11 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Series.XValues property (Excel)
vbaxl10.chm578112
vbaxl10.chm578112
Excel.Series.XValues
63715a3c-9d2d-6213-ac99-2c583773b45a
05/11/2019
medium

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.

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)

[!includeSupport and feedback]