Series.ApplyDataLabels(XlDataLabelsType, Object, Object, Object, Object, Object, Object, Object, Object, Object) Series.ApplyDataLabels(XlDataLabelsType, Object, Object, Object, Object, Object, Object, Object, Object, Object) Method

Definition

Applies data labels to a series.

public object ApplyDataLabels (Microsoft.Office.Interop.Word.XlDataLabelsType Type = Microsoft.Office.Interop.Word.XlDataLabelsType.xlDataLabelsShowValue, object LegendKey, object AutoText, object HasLeaderLines, object ShowSeriesName, object ShowCategoryName, object ShowValue, object ShowPercentage, object ShowBubbleSize, object Separator);
Public Function ApplyDataLabels (Optional Type As XlDataLabelsType = Microsoft.Office.Interop.Word.XlDataLabelsType.xlDataLabelsShowValue, Optional LegendKey As Object, Optional AutoText As Object, Optional HasLeaderLines As Object, Optional ShowSeriesName As Object, Optional ShowCategoryName As Object, Optional ShowValue As Object, Optional ShowPercentage As Object, Optional ShowBubbleSize As Object, Optional Separator As Object) As Object
Parameters
Type
XlDataLabelsType XlDataLabelsType

The type of data label to apply.

LegendKey
Object Object

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

AutoText
Object Object

True if the object automatically generates appropriate text based on content.

HasLeaderLines
Object Object

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

ShowSeriesName
Object Object

Pass a boolean value to enable or disable the series name for the data label.

ShowCategoryName
Object Object

Pass a boolean value to enable or disable the category name for the data label.

ShowValue
Object Object

Pass a boolean value to enable or disable the value for the data label.

ShowPercentage
Object Object

Pass a boolean value to enable or disable the percentage for the data label.

ShowBubbleSize
Object Object

Pass a boolean value to enable or disable the bubble size for the data label.

Separator
Object Object

The separator for the data label.

Returns

Returns Object.

Remarks

Type can be one of the XlDataLabelsType constants.

Applies to