Modifica

Condividi tramite


Point.ApplyDataLabels Method

Definition

Applies data labels to a point in a chart.

public object ApplyDataLabels (Microsoft.Office.Interop.Excel.XlDataLabelsType Type = Microsoft.Office.Interop.Excel.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.Excel.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

Optional XlDataLabelsType. The type of data label to apply. Can be one of the following XlDataLabelsType constants:xlDataLabelsShowBubbleSizesxlDataLabelsShowLabelAndPercent 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
Object

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

AutoText
Object

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

HasLeaderLines
Object

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

ShowSeriesName
Object

Optional Object. The series name for the data label.

ShowCategoryName
Object

Optional Object. The category name for the data label.

ShowValue
Object

Optional Object. The value for the data label.

ShowPercentage
Object

Optional Object. The percentage for the data label.

ShowBubbleSize
Object

Optional Object. The bubble size for the data label.

Separator
Object

Optional Object. The separator for the data label.

Returns

Applies to