이 페이지가 유용했습니까?
이 콘텐츠에 대한 여러분의 의견은 중요합니다. 의견을 알려주십시오.
추가 의견
1500자 남음
내보내기(0) 인쇄
모두 확장

Point.ApplyDataLabels Method (Excel)

Office 2010

Applies data labels to a point.

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

A variable that represents a Point object.

Parameters

Name

Required/Optional

Data Type

Description

Type

선택

XlDataLabelsType

The type of data label to apply.

LegendKey

선택

Variant

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

AutoText

선택

Variant

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

HasLeaderLines

선택

Variant

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

ShowSeriesName

선택

Variant

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

ShowCategoryName

선택

Variant

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

ShowValue

선택

Variant

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

ShowPercentage

선택

Variant

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

ShowBubbleSize

선택

Variant

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

Separator

선택

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
Microsoft는 MSDN 웹 사이트에 대한 귀하의 의견을 이해하기 위해 온라인 설문 조사를 진행하고 있습니다. 참여하도록 선택하시면 MSDN 웹 사이트에서 나가실 때 온라인 설문 조사가 표시됩니다.

참여하시겠습니까?
표시:
© 2015 Microsoft