Export (0) Print
Expand All

Series.ApplyDataLabels Method (Excel)

Applies data labels to a series.

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

expression A variable that represents a Series object.

Parameters

Name

Required/Optional

Data Type

Description

Type

Optional

XlDataLabelsType

The type of data label to apply.

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.

XlDataLabelsType can be one of these XlDataLabelsType constants.

xlDataLabelsShowBubbleSizes. The bubble size for the data label.

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

This example applies category labels to series one in Chart1.

Charts("Chart1").SeriesCollection(1). _ 
 ApplyDataLabels Type:=xlDataLabelsShowLabel
Show:
© 2014 Microsoft