Point Point Point Interface

Definition

Represents a single point in a series in a chart.

public interface class Point
[System.Runtime.InteropServices.Guid("0002086A-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface Point
Public Interface Point
Attributes

Remarks

The Point object is a member of the Points collection. The Points collection contains all the points in one series.

Use Points(index), where index is the point index number, to return a single Point object. Points are numbered from left to right on the series. Points(1) is the leftmost point, and Points(Points.Count) is the rightmost point.

Properties

Application Application Application

Returns an Application object that represents the Microsoft Excel application.

ApplyPictToEnd ApplyPictToEnd ApplyPictToEnd

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

ApplyPictToFront ApplyPictToFront ApplyPictToFront

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

ApplyPictToSides ApplyPictToSides ApplyPictToSides

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

Border Border Border

Returns a Border object that represents the border of the object.

Creator Creator Creator

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

DataLabel DataLabel DataLabel

Returns a DataLabel object that represents the data label associated with the point or trendline.

Explosion Explosion 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).

Fill Fill Fill

Returns a FillFormat object for a specified shape or a ChartFillFormat object for a specified chart that contains fill formatting properties for the shape or chart.

Format Format Format

Returns the ChartFormat object. Read-only.

Has3DEffect Has3DEffect Has3DEffect

Returns and Sets a value that states if a point has a three-dimensional appearance. Read/Write.

HasDataLabel HasDataLabel HasDataLabel

True if the point has a data label.

Height Height Height

Gets the height, in points, of the object.

Interior Interior Interior

Returns an Interior object that represents the interior of the specified object.

InvertIfNegative InvertIfNegative InvertIfNegative

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

Left Left Left

Gets a value that represents the distance, in points, from the left edge of the object to the left edge of the chart area.

MarkerBackgroundColor MarkerBackgroundColor 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.

MarkerBackgroundColorIndex MarkerBackgroundColorIndex 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.

MarkerForegroundColor MarkerForegroundColor MarkerForegroundColor

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

MarkerForegroundColorIndex MarkerForegroundColorIndex 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.

MarkerSize MarkerSize MarkerSize

Returns or sets the data marker size in points.

MarkerStyle MarkerStyle MarkerStyle

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

Name Name Name

Gets the object name.

Parent Parent Parent

Returns the parent object for the specified object.

PictureType PictureType PictureType

Returns or sets the way pictures are displayed on a column or bar picture chart.

PictureUnit PictureUnit PictureUnit

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).

PictureUnit2 PictureUnit2 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.

SecondaryPlot SecondaryPlot 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.

Shadow Shadow Shadow

True if the font is a shadow font or if the object has a shadow.

Top Top Top

Gets a value that represents the distance, in points, from the top edge of the object to the top edge of the chart area.

Width Width Width

Gets the width, in points, of the object.

Methods

_ApplyDataLabels(XlDataLabelsType, Object, Object, Object) _ApplyDataLabels(XlDataLabelsType, Object, Object, Object) _ApplyDataLabels(XlDataLabelsType, Object, Object, Object)

Reserved for internal use.

ApplyDataLabels(XlDataLabelsType, Object, Object, Object, Object, Object, Object, Object, Object, Object) ApplyDataLabels(XlDataLabelsType, Object, Object, Object, Object, Object, Object, Object, Object, Object) ApplyDataLabels(XlDataLabelsType, Object, Object, Object, Object, Object, Object, Object, Object, Object)

Applies data labels to a point in a chart.

ClearFormats() ClearFormats() ClearFormats()

Clears the formatting of the object.

Copy() Copy() Copy()

If the point or series has a picture fill, copies the picture to the Clipboard.

Delete() Delete() Delete()

Deletes the object.

Paste() Paste() Paste()

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

PieSliceLocation(XlPieSliceLocation, XlPieSliceIndex) PieSliceLocation(XlPieSliceLocation, XlPieSliceIndex) PieSliceLocation(XlPieSliceLocation, XlPieSliceIndex)

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() Select() Select()

Selects the object.

Applies to