Excel.Interfaces.ChartDataLabelsData interface

描述通过调用 "chartDataLabels ()" 返回的数据的接口。An interface describing the data returned by calling "chartDataLabels.toJSON()".

属性

autoText

表示数据标签是否根据上下文自动生成相应的文本。Represents whether data labels automatically generate appropriate text based on context.

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

format

表示图表数据标签的格式,包括填充和字体格式。Represents the format of chart data labels, which includes fill and font formatting. 只读。Read-only.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

horizontalAlignment

表示图表数据标签水平对齐。Represents the horizontal alignment for chart data label. 有关详细信息, 请参阅 ChartTextHorizontalAlignment。See Excel.ChartTextHorizontalAlignment 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 ]

linkNumberFormat

表示数字格式是否链接到单元格。Represents whether or not the number format is linked to the cells. 如果为 true, 则数字格式在单元格更改时将在标签中更改If true, the number format will change in the labels when it changes in the cells

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

numberFormat

表示数据标签的格式代码。Represents the format code for data labels.

[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.1][ API set: ExcelApi 1.1 ]

separator

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

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

showBubbleSize

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

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

showCategoryName

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

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

showLegendKey

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

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

showPercentage

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

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

showSeriesName

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

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

showValue

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

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

textOrientation

表示数据标签的文本方向。Represents the text orientation of data labels. 此值应是 -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 ]

verticalAlignment

表示图表数据标签垂直对齐。Represents the vertical alignment of chart data label. 有关详细信息, 请参阅 ChartTextVerticalAlignment。See Excel.ChartTextVerticalAlignment 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 ]

属性详细信息

autoText

表示数据标签是否根据上下文自动生成相应的文本。Represents whether data labels automatically generate appropriate text based on context.

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

autoText?: boolean;

属性值

boolean

format

表示图表数据标签的格式,包括填充和字体格式。Represents the format of chart data labels, which includes fill and font formatting. 只读。Read-only.

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

format?: Excel.Interfaces.ChartDataLabelFormatData;

属性值

horizontalAlignment

表示图表数据标签水平对齐。Represents the horizontal alignment for chart data label. 有关详细信息, 请参阅 ChartTextHorizontalAlignment。See Excel.ChartTextHorizontalAlignment 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 ]

horizontalAlignment?: Excel.ChartTextHorizontalAlignment | "Center" | "Left" | "Right" | "Justify" | "Distributed";

属性值

Excel.ChartTextHorizontalAlignment | "Center" | "Left" | "Right" | "Justify" | "Distributed"

linkNumberFormat

表示数字格式是否链接到单元格。Represents whether or not the number format is linked to the cells. 如果为 true, 则数字格式在单元格更改时将在标签中更改If true, the number format will change in the labels when it changes in the cells

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

linkNumberFormat?: boolean;

属性值

boolean

numberFormat

表示数据标签的格式代码。Represents the format code for data labels.

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

numberFormat?: string;

属性值

string

position

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

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

position?: Excel.ChartDataLabelPosition | "Invalid" | "None" | "Center" | "InsideEnd" | "InsideBase" | "OutsideEnd" | "Left" | "Right" | "Top" | "Bottom" | "BestFit" | "Callout";

属性值

Excel.ChartDataLabelPosition | "Invalid" | "None" | "Center" | "InsideEnd" | "InsideBase" | "OutsideEnd" | "Left" | "Right" | "Top" | "Bottom" | "BestFit" | "Callout"

separator

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

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

separator?: string;

属性值

string

showBubbleSize

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

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

showBubbleSize?: boolean;

属性值

boolean

showCategoryName

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

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

showCategoryName?: boolean;

属性值

boolean

showLegendKey

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

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

showLegendKey?: boolean;

属性值

boolean

showPercentage

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

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

showPercentage?: boolean;

属性值

boolean

showSeriesName

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

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

showSeriesName?: boolean;

属性值

boolean

showValue

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

[API 集: ExcelApi 1.1][ API set: ExcelApi 1.1 ]

showValue?: boolean;

属性值

boolean

textOrientation

表示数据标签的文本方向。Represents the text orientation of data labels. 此值应是 -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?: number;

属性值

number

verticalAlignment

表示图表数据标签垂直对齐。Represents the vertical alignment of chart data label. 有关详细信息, 请参阅 ChartTextVerticalAlignment。See Excel.ChartTextVerticalAlignment 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 ]

verticalAlignment?: Excel.ChartTextVerticalAlignment | "Center" | "Bottom" | "Top" | "Justify" | "Distributed";

属性值

Excel.ChartTextVerticalAlignment | "Center" | "Bottom" | "Top" | "Justify" | "Distributed"