Point Methods

Name Returns Parameters Description

ApplyData Labels

Variant

[Type As

Applies the data label properties

XlDataLabels

specified by the parameters to

Type],

the point. The Type parameter

[LegendKey],

specifies whether no label, a

[AutoText],

value, a percentage of the whole,

[HasLeader

or a category label is shown. The

Lines],

legend key can appear by the

[ShowSeries

point by setting the LegendKey

Name] ,

parameter to True. Set

[ShowCategory

AutoText to True if the object

Name] ,

automatically generates

[ShowValue],

appropriate text based on

[Show

content. HasLeaderLines

Percentage] ,

should be set to True if the series

[ShowBubble

has leader lines. All the other

Size] ,

parameters are simply the

[Separator]

properties of the data labels that

they describe

Name Returns Parameters Description

ClearFormats Variant Clears the formatting made to a point

ClearFormats Variant Clears the formatting made to a point

Copy

Variant

Cuts the point and places it in the clipboard

Delete

Variant

Deletes the point

Paste

Variant

Pastes the picture in the clipboard into the current point so it becomes the marker

Select

Variant

Selects the point on the chart

Was this article helpful?

0 0

Post a comment