Chart.ApplyDataLabels (Excel)

Applies data labels to all the series in a chart.

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

Charts("Chart1").SeriesCollection(1). _ 
 ApplyDataLabels Type:=xlDataLabelsShowLabel

Arguments

Optional arguments

The following arguments are optional

Type (XlDataLabelsType) - The type of data label to apply.


Possible Values are

xlDataLabelsShowBubbleSizes Show the size of the bubble in reference to the absolute value.
xlDataLabelsShowLabel Category for the point.
xlDataLabelsShowLabelAndPercent Percentage of the total, and category for the point. Available only for pie charts and doughnut charts.
xlDataLabelsShowNone No data labels.
xlDataLabelsShowPercent Percentage of the total. Available only for pie charts and doughnut charts.
xlDataLabelsShowValue 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 value 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 - Pass a Boolean value to enable or disable the series name for the data label

ShowCategoryName - Pass a Boolean value to enable or disable the category name for the data label

ShowValue - Pass a Boolean value to enable or disable the value for the data label

ShowPercentage - Pass a Boolean value to enable or disable the percentage for the data label

ShowBubbleSize - Pass a Boolean value to enable or disable the bubble size for the data label

Separator - The separator for the data label

Chart.ApplyDataLabels procedure builder