Point Members

Include Protected Members
Include Inherited Members

Represents a single point in a series in a chart.

The Point type exposes the following members.

Properties

	Name	Description
	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.

Top

Methods

	Name	Description
	_ApplyDataLabels	Reserved for internal use.
	ApplyDataLabels	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	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.

Top

See Also

Reference

Point Interface

Microsoft.Office.Interop.Excel Namespace