Chart.ApplyDataLabels Method

Definition

Namespace:

Microsoft.Office.Interop.Word

Assembly:

Microsoft.Office.Interop.Word.dll

Applies data labels to all the series in a chart.

public void 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);

abstract member ApplyDataLabels : Microsoft.Office.Interop.Word.XlDataLabelsType * obj * obj * obj * obj * obj * obj * obj * obj * obj -> unit

Public Sub 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)

Parameters

Type

XlDataLabelsType

Required XlDataLabelsType The type of data label to apply.

LegendKey

Object

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

AutoText

Object

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

HasLeaderLines

Object

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

ShowSeriesName

Object

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

ShowCategoryName

Object

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

ShowValue

Object

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

ShowPercentage

Object

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

ShowBubbleSize

Object

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

Separator

Object

The separator for the data label.

Remarks

The following table shows the XlDataLabelsType arguments that can be passed to the Type parameter of a ApplyDataLabels(XlDataLabelsType, Object, Object, Object, Object, Object, Object, Object, Object, Object) method.

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