Excel.Interfaces.ChartDataLabelLoadOptions interface

表示图表点的数据标签。Represents the data label of a chart point.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

属性

$all
autoText

该布尔值表示数据标签是否根据上下文自动生成相应的文本。Boolean value representing if data label automatically generates appropriate text based on context.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

format

表示图表数据标签的格式。Represents the format of chart data label.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

formula

该字符串值表示采用 A1 表示法的图表数据标签的公式。String value that represents the formula of chart data label using A1-style notation.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

height

返回图表数据标签的高度,以磅为单位。Returns the height, in points, of the chart data label. 只读。Read-only. 如果图表数据标签不可见,则为 Null。Null if chart data label is not visible.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

horizontalAlignment

表示图表数据标签水平对齐。Represents the horizontal alignment for chart data label. 有关详细信息, 请参阅 ChartTextHorizontalAlignment。See Excel.ChartTextHorizontalAlignment for details. 仅当 TextOrientation 的数据标签为90、-90 或180时, 此属性才有效。This property is valid only when TextOrientation of data label is 90, -90 or 180.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

left

表示图表数据标签左边缘到图表区域左边缘的距离,以磅为单位。Represents the distance, in points, from the left edge of chart data label to the left edge of chart area. 如果图表数据标签不可见,则为 Null。Null if chart data label is not visible.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

linkNumberFormat

布尔值,表示数字格式是否链接到单元格(以便在单元格中更改时标签中的数字格式会发生改变)。Boolean value representing if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells).

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

numberFormat

该字符串值表示数据标签的格式代码。String value that represents the format code for data label.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

position

表示数据标签的位置的 DataLabelPosition 值。DataLabelPosition value that represents the position of the data label. 有关详细信息, 请参阅 ChartDataLabelPosition。See Excel.ChartDataLabelPosition for details.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

separator

该字符串表示用于图表中数据标签的分隔符。String representing the separator used for the data label on a chart.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

showBubbleSize

该布尔值表示数据标签气泡大小是否可见。Boolean value representing if the data label bubble size is visible or not.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

showCategoryName

表示数据标签分类名称是否可见的布尔值。Boolean value representing if the data label category name is visible or not.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

showLegendKey

该布尔值表示数据标签图例标示是否可见。Boolean value representing if the data label legend key is visible or not.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

showPercentage

该布尔值表示数据标签百分比是否可见。Boolean value representing if the data label percentage is visible or not.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

showSeriesName

该布尔值表示数据标签系列名称是否可见。Boolean value representing if the data label series name is visible or not.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

showValue

该布尔值表示数据标签值是否可见。Boolean value representing if the data label value is visible or not.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

text

该字符串表示图表上的数据标签文本。String representing the text of the data label on a chart.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

textOrientation

表示图表数据标签的文本方向。Represents the text orientation of chart data label. 此值应是 -90 到 90 或 180(垂直文本)之间的整数。The value should be an integer either from -90 to 90, or 180 for vertically-oriented text.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

top

表示图表数据标签上边缘到图表区域顶部的距离,以磅为单位。Represents the distance, in points, from the top edge of chart data label to the top of chart area. 如果图表数据标签不可见,则为 Null。Null if chart data label is not visible.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

verticalAlignment

表示图表数据标签垂直对齐。Represents the vertical alignment of chart data label. 有关详细信息, 请参阅 ChartTextVerticalAlignment。See Excel.ChartTextVerticalAlignment for details. 仅当 TextOrientation 的数据标签为0时, 此属性才有效。This property is valid only when TextOrientation of data label is 0.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

width

返回图表数据标签的宽度,以磅为单位。Returns the width, in points, of the chart data label. 只读。Read-only. 如果图表数据标签不可见,则为 Null。Null if chart data label is not visible.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

属性详细信息

$all

$all?: boolean;

属性值

boolean

autoText

该布尔值表示数据标签是否根据上下文自动生成相应的文本。Boolean value representing if data label automatically generates appropriate text based on context.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

autoText?: boolean;

属性值

boolean

format

表示图表数据标签的格式。Represents the format of chart data label.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

format?: Excel.Interfaces.ChartDataLabelFormatLoadOptions;

属性值

formula

该字符串值表示采用 A1 表示法的图表数据标签的公式。String value that represents the formula of chart data label using A1-style notation.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

formula?: boolean;

属性值

boolean

height

返回图表数据标签的高度,以磅为单位。Returns the height, in points, of the chart data label. 只读。Read-only. 如果图表数据标签不可见,则为 Null。Null if chart data label is not visible.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

height?: boolean;

属性值

boolean

horizontalAlignment

表示图表数据标签水平对齐。Represents the horizontal alignment for chart data label. 有关详细信息, 请参阅 ChartTextHorizontalAlignment。See Excel.ChartTextHorizontalAlignment for details. 仅当 TextOrientation 的数据标签为90、-90 或180时, 此属性才有效。This property is valid only when TextOrientation of data label is 90, -90 or 180.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

horizontalAlignment?: boolean;

属性值

boolean

left

表示图表数据标签左边缘到图表区域左边缘的距离,以磅为单位。Represents the distance, in points, from the left edge of chart data label to the left edge of chart area. 如果图表数据标签不可见,则为 Null。Null if chart data label is not visible.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

left?: boolean;

属性值

boolean

linkNumberFormat

布尔值,表示数字格式是否链接到单元格(以便在单元格中更改时标签中的数字格式会发生改变)。Boolean value representing if the number format is linked to the cells (so that the number format changes in the labels when it changes in the cells).

[API 集: ExcelApi 1.9][ API set: ExcelApi 1.9 ]

linkNumberFormat?: boolean;

属性值

boolean

numberFormat

该字符串值表示数据标签的格式代码。String value that represents the format code for data label.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

numberFormat?: boolean;

属性值

boolean

position

表示数据标签的位置的 DataLabelPosition 值。DataLabelPosition value that represents the position of the data label. 有关详细信息, 请参阅 ChartDataLabelPosition。See Excel.ChartDataLabelPosition for details.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

position?: boolean;

属性值

boolean

separator

该字符串表示用于图表中数据标签的分隔符。String representing the separator used for the data label on a chart.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

separator?: boolean;

属性值

boolean

showBubbleSize

该布尔值表示数据标签气泡大小是否可见。Boolean value representing if the data label bubble size is visible or not.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

showBubbleSize?: boolean;

属性值

boolean

showCategoryName

表示数据标签分类名称是否可见的布尔值。Boolean value representing if the data label category name is visible or not.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

showCategoryName?: boolean;

属性值

boolean

showLegendKey

该布尔值表示数据标签图例标示是否可见。Boolean value representing if the data label legend key is visible or not.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

showLegendKey?: boolean;

属性值

boolean

showPercentage

该布尔值表示数据标签百分比是否可见。Boolean value representing if the data label percentage is visible or not.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

showPercentage?: boolean;

属性值

boolean

showSeriesName

该布尔值表示数据标签系列名称是否可见。Boolean value representing if the data label series name is visible or not.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

showSeriesName?: boolean;

属性值

boolean

showValue

该布尔值表示数据标签值是否可见。Boolean value representing if the data label value is visible or not.

[API 集: ExcelApi 1.7][ API set: ExcelApi 1.7 ]

showValue?: boolean;

属性值

boolean

text

该字符串表示图表上的数据标签文本。String representing the text of the data label on a chart.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

text?: boolean;

属性值

boolean

textOrientation

表示图表数据标签的文本方向。Represents the text orientation of chart data label. 此值应是 -90 到 90 或 180(垂直文本)之间的整数。The value should be an integer either from -90 to 90, or 180 for vertically-oriented text.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

textOrientation?: boolean;

属性值

boolean

top

表示图表数据标签上边缘到图表区域顶部的距离,以磅为单位。Represents the distance, in points, from the top edge of chart data label to the top of chart area. 如果图表数据标签不可见,则为 Null。Null if chart data label is not visible.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

top?: boolean;

属性值

boolean

verticalAlignment

表示图表数据标签垂直对齐。Represents the vertical alignment of chart data label. 有关详细信息, 请参阅 ChartTextVerticalAlignment。See Excel.ChartTextVerticalAlignment for details. 仅当 TextOrientation 的数据标签为0时, 此属性才有效。This property is valid only when TextOrientation of data label is 0.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

verticalAlignment?: boolean;

属性值

boolean

width

返回图表数据标签的宽度,以磅为单位。Returns the width, in points, of the chart data label. 只读。Read-only. 如果图表数据标签不可见,则为 Null。Null if chart data label is not visible.

[API 集: ExcelApi 1.8][ API set: ExcelApi 1.8 ]

width?: boolean;

属性值

boolean