Chart.ApplyDataLabels Method (Excel)

Applies data labels to all the series in a chart.

Syntax

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

expression A variable that represents a Chart 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.

Remarks

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

Example

This example applies category labels to series one in Chart1.

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

請參閱

概念

Chart Object

Chart Object Members