Export (0) Print
Expand All

Point 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.
HasDataLabel True if the point has a data label.
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.
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.
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).
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.

Community Additions

ADD
Show:
© 2014 Microsoft