Class Point (Word VBA)

The class Point represents a single point in a series in a chart.

The main procedures of class Point are Copy, Delete and Select

For Each

Here is an example of processing the Point items in a collection.

Dim shpn As ShapeNode: Set shpn = 
Dim pnt As Point
For Each pnt In shpn.Points
	With pnt
		
	End With
Next pnt

Themes

The following procedures in this class have been grouped together and are described on a separate theme page

Format with its procedures ClearFormats, Format, MarkerBackgroundColor, MarkerBackgroundColorIndex, MarkerForegroundColor, MarkerForegroundColorIndex and MarkerStyle

Methods

These are the main methods of the Point class

Copy - If the point has a picture fill, copies the picture to the Clipboard.

7 
pnt.Copy

Delete - Deletes the object.

7 
pnt.Delete

Select - Selects the object.

7 
pnt.Select

Other Methods

ApplyDataLabels - Applies data labels to a point.

7 
pnt.ApplyDataLabels

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.

7 
Dim dblPieSliceLocation As Double
dblPieSliceLocation = pnt.PieSliceLocation(loc:=xlHorizontalCoordinate)

Properties

ApplyPictToEnd true if a picture is applied to the end of the point or all points in the series.

7 
pnt.ApplyPictToEnd = True

ApplyPictToFront true if a picture is applied to the front of the point or all points in the series.

7 
pnt.ApplyPictToFront = True

ApplyPictToSides true if a picture is applied to the sides of the point or all points in the series.

7 
pnt.ApplyPictToSides = True

DataLabel returns the data label associated with the point.

7 
Dim dtlDataLabel As DataLabel
Set dtlDataLabel = pnt.DataLabel

Explosion returns or sets the explosion value for a pie-chart or doughnut-chart slice.

7 
pnt.Explosion =

Has3DEffect true if a point has a three-dimensional appearance.

7 
pnt.Has3DEffect = True

HasDataLabel true if the point has a data label.

7 
pnt.HasDataLabel = True

Height returns the height, in points, of the object.

7 
Dim dblHeight As Double
dblHeight = pnt.Height

InvertIfNegative true if Microsoft Word inverts the pattern in the object when it corresponds to a negative number.

7 
pnt.InvertIfNegative = True

IsTotal true if the point represents a total.

7 
pnt.IsTotal = True

Left returns a value that represents the distance, in points, from the left edge of the object to the left edge of the chart area.

7 
Dim dblLeft As Double
dblLeft = pnt.Left

MarkerSize returns or sets the data-marker size, in points.

7 
pnt.MarkerSize =

Name returns the object name.

7 
Dim strName As String
strName = pnt.Name

Parent returns the parent for the specified object. Read-only object.

7 
Dim objParent As Object
Set objParent = pnt.Parent

PictureType returns or sets a value that specifies how pictures are displayed on a column or bar picture chart.

7 
pnt.PictureType = xlStack

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).

7 
pnt.PictureUnit2 =

SecondaryPlot true if the point is in the secondary section of either a pie-of-pie chart or a bar-of-pie chart.

7 
pnt.SecondaryPlot = True

Shadow returns or sets a value that indicates whether the object has a shadow.

7 
pnt.Shadow = True

Top returns a value that represents the distance, in points, from the top edge of the object to the top edge of the chart area.

7 
Dim dblTop As Double
dblTop = pnt.Top

Width returns the width, in points, of the object.

7 
Dim dblWidth As Double
dblWidth = pnt.Width

Points.Count returns the number of objects in the collection.

Dim pnts As Points: Set pnts =  
Dim lngCount As Long
lngCount = pnts.Count

Points.Parent returns the parent for the specified object. Read-only object.

Dim pnts As Points: Set pnts =  
Dim objParent As Object
Set objParent = pnts.Parent