Value related procedures in class Series (PowerPoint VBA)

This page presents procedures from class Series related to the theme Value: Values and XValues


Returns or sets a collection of all the values in the series.

The value of this property can be either the address of a range on the chart's worksheet or an array of constant values, but not a combination of both. See the examples for details.

ActivePresentation.Slides(1).Shapes(1).Chart.FullSeriesCollection(1).Values = "=Sheet1!B2:B5"


Returns or sets an array of x values for a chart series.

You can set the XValues property to a range on a worksheet or to an array of values, but not to a combination of both. For PivotChart reports, this property is read-only.

ActivePresentation.Slides(1).Shapes(1).Chart.FullSeriesCollection(1).XValues = "=Sheet1!B2:B5"