Point Members (Excel)

Represents a single point in a series in a chart.

Name

Description

ApplyDataLabels

Applies data labels to a point.

ClearFormats

Clears the formatting of the object.

Copy

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

Delete

Deletes the series the point belongs to.

Paste

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

PieSliceLocation

Returns the vertical or horizontal position of a point on a chart item, in points, from the top or left edge of the object to the top or left edge of the chart area.

Select

Selects the object.

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.

ApplyPictToEnd

True if a picture is applied to the end of the point or all points in the series. Read/write Boolean.

ApplyPictToFront

True if a picture is applied to the front of the point or all points in the series. Read/write Boolean.

ApplyPictToSides

True if a picture is applied to the sides of the point or all points in the series. Read/write Boolean.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

DataLabel

Returns a DataLabel object that represents the data label associated with the point. Read-only.

Explosion

Returns or sets the explosion value for a pie-chart or doughnut-chart slice. Returns 0 (zero) if there's no explosion (the tip of the slice is in the center of the pie). Read/write Long.

Format

Returns the ChartFormat object. Read-only.

Has3DEffect

True if a point has a three-dimensional appearance. Read/write Boolean.

HasDataLabel

True if the point has a data label. Read/write Boolean.

Height

Returns the height, in points, of the object. Read-only.

InvertIfNegative

True if Microsoft Excel inverts the pattern in the item when it corresponds to a negative number. Read/write Boolean.

Left

Returns a value that represents the distance, in points, from the left edge of the object to the left edge of the chart area. Read-only.

MarkerBackgroundColor

Sets the marker background color as an RGB value or returns the corresponding color index value. Applies only to line, scatter, and radar charts. Read/write Long.

MarkerBackgroundColorIndex

Returns or sets the marker background color as an index into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone. Applies only to line, scatter, and radar charts. Read/write Long.

MarkerForegroundColor

Sets the marker foreground color as an RGB value or returns the corresponding color index value. Applies only to line, scatter, and radar charts. Read/write Long.

MarkerForegroundColorIndex

Returns or sets the marker foreground color as an index into the current color palette, or as one of the following XlColorIndex constants: xlColorIndexAutomatic or xlColorIndexNone. Applies only to line, scatter, and radar charts. Read/write Long.

MarkerSize

Returns or sets the data-marker size, in points. Can be a value from 2 through 72. Read/write Long.

MarkerStyle

Returns or sets the marker style for a point or series in a line chart, scatter chart, or radar chart. Read/write XlMarkerStyle.

Name

Returns the object name. Read-only.

Parent

Returns the parent object for the specified object. Read-only.

PictureType

Returns or sets a XlChartPictureType value that represents the way pictures are displayed on a column or bar picture chart.

PictureUnit2

Returns or sets the unit for each picture on the chart if the PictureType property is set to xlStackScale (if not, this property is ignored). Read/write Double.

SecondaryPlot

True if the point is in the secondary section of either a pie of pie chart or a bar of pie chart. Applies only to points on pie of pie charts or bar of pie charts. Read/write Boolean.

Shadow

Returns or sets a Boolean value that determines if the object has a shadow.

Top

Returns a value that represents the distance, in points, from the top edge of the object to the top edge of the chart area. Read-only.

Width

Returns the width, in points, of the object. Read-only.

Show:
© 2015 Microsoft