Point members

Represents a single point in a series in a chart.

The Point type exposes the following members.

  Name Description
Public property Application When used without an object qualifier, this property returns an _Application object that represents the Microsoft Word 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.
Public property ApplyPictToEnd True if a picture is applied to the end of the point or all points in the series. Read/write Boolean.
Public property ApplyPictToFront True if a picture is applied to the front of the point or all points in the series. Read/write Boolean.
Public property ApplyPictToSides True if a picture is applied to the sides of the point or all points in the series. Read/write Boolean.
Public property Border Returns a Border object that represents the border of the object.
Public property Creator Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Integer.
Public property DataLabel Returns a DataLabel object that represents the data label associated with the point. Read-only.
Public property 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 Integer.
Public property 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.
Public property Format Returns the line, fill, and effect formatting for the object. Read-only ChartFormat.
Public property Has3DEffect True if a point has a three-dimensional appearance. Read/write Boolean.
Public property HasDataLabel True if the point has a data label. Read/write Boolean.
Public property Height Gets the height, in points, of the object.
Public property Interior Returns an Interior object that represents the interior of the specified object.
Public property InvertIfNegative True if Microsoft Word inverts the pattern in the object when it corresponds to a negative number. Read/write Boolean.
Public property 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.
Public property 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 Integer.
Public property 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 XlColorIndex.
Public property 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 Integer.
Public property 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 XlColorIndex.
Public property MarkerSize Returns or sets the data-marker size, in points. Can be a value from 2 through 72. Read/write Integer.
Public property MarkerStyle Returns or sets the marker style for a point or series in a line chart, scatter chart, or radar chart. Read/write XlMarkerStyle.
Public property Name Gets the object name.
Public property Parent Returns the parent for the specified object. Read-only Object.
Public property PictureType Returns or sets a XlChartPictureType value that represents the way pictures are displayed on a column or bar picture chart.
Public property 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).
Public property 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.
Public property 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.
Public property Shadow Returns or sets a Boolean value that determines if the object has a shadow.
Public property 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.
Public property Width Gets the width, in points, of the object.
Top

  Name Description
Public method ApplyDataLabels Applies data labels to a point.
Public method ClearFormats Clears the formatting of the object.
Public method Copy If the point has a picture fill, then this method copies the picture to the Clipboard.
Public method Delete Deletes the object.
Public method Paste Pastes a picture from the Clipboard as the marker on the selected point.
Public method PieSliceLocation Gets 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.
Public method Select Selects the object.
Top
Show:
© 2014 Microsoft