Series Methods (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Name

Description

ApplyDataLabels

Applies data labels to a series.

ClearFormats

Clears the formatting of the object.

Copy

If the series has a picture fill, then this method copies the picture to the Clipboard.

DataLabels

Returns an object that represents either a single data label (a DataLabel object) or a collection of all the data labels for the series (a DataLabels collection).

Delete

Deletes the object.

ErrorBar

Applies error bars to the series. Variant.

Paste

Pastes a picture from the Clipboard as the marker on the selected series.

Points

Returns an object that represents a single point (a Point object) or a collection of all the points (a Points collection) in the series. Read-only

Select

Selects the object.

Trendlines

Returns an object that represents a single trendline (a Trendline object) or a collection of all the trendlines (a Trendlines collection) for the series.

Show: