Point Object Members

  • Article
Excel Developer Reference

Represents a single point in a series in a chart.

Methods

  Name Description
Bb256118.methods(en-us,office.12).gif ApplyDataLabels Applies data labels to a point.
Bb256118.methods(en-us,office.12).gif ClearFormats Clears the formatting of the object.
Bb256118.methods(en-us,office.12).gif Copy If the point has a picture fill, then this method copies the picture to the Clipboard.
Bb256118.methods(en-us,office.12).gif Delete Deletes the series the point belongs to.
Bb256118.methods(en-us,office.12).gif Paste Pastes a picture from the Clipboard as the marker on the selected point.
Bb256118.methods(en-us,office.12).gif Select Selects the object.

Properties

  Name Description
Bb256118.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel 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.
Bb256118.properties(en-us,office.12).gif ApplyPictToEnd True if a picture is applied to the end of the point or all points in the series. Read/write Boolean.
Bb256118.properties(en-us,office.12).gif ApplyPictToFront True if a picture is applied to the front of the point or all points in the series. Read/write Boolean.
Bb256118.properties(en-us,office.12).gif ApplyPictToSides True if a picture is applied to the sides of the point or all points in the series. Read/write Boolean.
Bb256118.properties(en-us,office.12).gif DataLabel Returns a DataLabel object that represents the data label associated with the point. Read-only.
Bb256118.properties(en-us,office.12).gif 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 Long.
Bb256118.properties(en-us,office.12).gif Format Read-only
Bb256118.properties(en-us,office.12).gif Has3DEffect Read/write
Bb256118.properties(en-us,office.12).gif HasDataLabel True if the point has a data label. Read/write Boolean.
Bb256118.properties(en-us,office.12).gif InvertIfNegative True if Microsoft Excel inverts the pattern in the item when it corresponds to a negative number. Read/write Boolean.
Bb256118.properties(en-us,office.12).gif 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 Long.
Bb256118.properties(en-us,office.12).gif 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 Long.
Bb256118.properties(en-us,office.12).gif 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. Read/write Long.
Bb256118.properties(en-us,office.12).gif 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 Long.
Bb256118.properties(en-us,office.12).gif MarkerSize Returns or sets the data-marker size, in points. Can be a value from 2 through 72. Read/write Long.
Bb256118.properties(en-us,office.12).gif MarkerStyle Returns or sets the marker style for a point or series in a line chart, scatter chart, or radar chart. Read/write XlMarkerStyle.
Bb256118.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb256118.properties(en-us,office.12).gif PictureType Returns or sets a XlChartPictureType value that represents the way pictures are displayed on a column or bar picture chart.
Bb256118.properties(en-us,office.12).gif 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). Read/write Long.
Bb256118.properties(en-us,office.12).gif PictureUnit2 Read/write
Bb256118.properties(en-us,office.12).gif 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.
Bb256118.properties(en-us,office.12).gif Shadow Returns or sets a Boolean value that determines if the object has a shadow.