Point.ApplyDataLabels procedure builder

Point.ApplyDataLabels (Word)

Applies data labels to a point.

ApplyDataLabels (Type, LegendKey, AutoText, HasLeaderLines, ShowSeriesName, ShowCategoryName, ShowValue, ShowPercentage, ShowBubbleSize, Separator)

With ActiveDocument.InlineShapes(1) 
 If .HasChart Then 
 .Chart.SeriesCollection(1). _ 
 ApplyDataLabels Type:=xlDataLabelsShowLabel 
 End If 
End With

Arguments

Optional arguments

The following arguments are optional

Type (XlDataLabelsType) - The type of data label to apply. Can be one of the xlDataLabelsType constants.


Possible Values are

xlDataLabelsShowBubbleSizes Show the size of the bubble in reference to the absolute value.
xlDataLabelsShowLabel The category for the point.
xlDataLabelsShowLabelAndPercent The percentage of the total, and the category for the point. Available only for pie charts and doughnut charts.
xlDataLabelsShowNone No data labels.
xlDataLabelsShowPercent The percentage of the total. Available only for pie charts and doughnut charts.
xlDataLabelsShowValue The default value for the point (assumed if this argument is not specified).

LegendKey - True to show the legend key next to the point. The default is False

AutoText - True if the object automatically generates appropriate text based on content

HasLeaderLines - For the Chart and Series objects, True if the series has leader lines

ShowSeriesName - True to enable the series name for the data label; otherwise, False

ShowCategoryName - True to enable the category name for the data label; otherwise, False

ShowValue - True to enable the value for the data label; otherwise, False

ShowPercentage - True to enable the percentage for the data label; otherwise, False

ShowBubbleSize - True to enable the bubble size for the data label; otherwise, False

Separator - The separator for the data label