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 |
Returns an Application object that represents the Microsoft Excel application. |
ApplyPictToEnd |
True if a picture is applied to the end of the point or all points in the series. |
ApplyPictToFront |
True if a picture is applied to the front of the point or all points in the series. |
ApplyPictToSides |
True if a picture is applied to the sides of the point or all points in the series. |
Border |
Returns a Border object that represents the border of the object. |
Creator |
Returns a 32-bit integer that indicates the application in which this object was created. |
DataLabel |
Returns a DataLabel object that represents the data label associated with the point or trendline. |
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 |
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 |
Returns the ChartFormat object. Read-only. |
Has3DEffect |
Returns and Sets a value that states if a point has a three-dimensional appearance. Read/Write. |
HasDataLabel |
True if the point has a data label. |
Height |
Gets the height, in points, of the object. |
Interior |
Returns an Interior object that represents the interior of the specified object. |
InvertIfNegative |
True if Microsoft Excel inverts the pattern in the item when it corresponds to a negative number. |
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 |
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 |
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 |
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 |
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 |
Returns or sets the data marker size in points. |
MarkerStyle |
Returns or sets the marker style for a point or series in a line chart, scatter chart, or radar chart. |
Name |
Gets the object name. |
Parent |
Returns the parent object for the specified object. |
PictureType |
Returns or sets the way pictures are displayed on a column or bar picture chart. |
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 |
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 |
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 |
True if the font is a shadow font or if the object has a shadow. |
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 |
Gets the width, in points, of the object. |
Methods
_ApplyDataLabels(XlDataLabelsType, Object, Object, Object) |
Reserved for internal use. |
ApplyDataLabels(XlDataLabelsType, Object, Object, Object, Object, Object, Object, Object, Object, Object) |
Applies data labels to a point in a chart. |
ClearFormats() |
Clears the formatting of the object. |
Copy() |
If the point or series has a picture fill, copies the picture to the Clipboard. |
Delete() |
Deletes the object. |
Paste() |
Pastes a picture from the Clipboard as the marker on the selected point. |
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() |
Selects the object. |