ApplyDataLabels Method [Excel 2003 VBA Language Reference]
Applies data labels to a point, a series, or all the series in a chart.
expression.ApplyDataLabels(Type, LegendKey, AutoText, HasLeaderLines, ShowSeriesName, ShowCategoryName, ShowValue, ShowPercentage, ShowBubbleSize, Separator)
expression Required. An expression that returns one of the objects in the Applies To list.
XlDataLabelsType
XlDataLabelsType can be one of these XlDataLabelsType constants. |
xlDataLabelsShowBubbleSizes |
xlDataLabelsShowLabelAndPercent. Percentage of the total, and category for the point. Available only for pie charts and doughnut charts. |
xlDataLabelsShowPercent. Percentage of the total. Available only for pie charts and doughnut charts. |
xlDataLabelsShowLabel. Category for the point. |
xlDataLabelsShowNone. No data labels. |
xlDataLabelsShowValue. default. Value for the point (assumed if this argument isn't specified). |
LegendKey Optional Variant. True to show the legend key next to the point. The default value is False.
AutoText Optional Variant. True if the object automatically generates appropriate text based on content.
HasLeaderLines Optional Variant. For the Chart and Series objects, True if the series has leader lines.
ShowSeriesName Optional Variant. Pass a boolean value to enable or disable the series name for the data label.
ShowCategoryName Optional Variant. Pass a boolean value to enable or disable the category name for the data label.
ShowValue Optional Variant. Pass a boolean value to enable or disable the value for the data label.
ShowPercentage Optional Variant. Pass a boolean value to enable or disable the percentage for the data label.
ShowBubbleSize Optional Variant. Pass a boolean value to enable or disable the bubble size for the data label.
Separator Optional Variant. The separator for the data label.
Example
This example applies category labels to series one in Chart1.
Charts("Chart1").SeriesCollection(1). _
ApplyDataLabels Type:=xlDataLabelsShowLabel
Applies to | Chart Object | Point Object | Series Object
See Also | DataLabel Property | HasDataLabel Property | HasDataLabels Property