Excel.Interfaces.ChartLoadOptions interface

表示工作簿中的 chart 对象。Represents a chart object in a workbook.

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

属性

$all
axes

表示图表坐标轴。Represents chart axes.

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

categoryLabelLevel

返回或设置 ChartCategoryLabelLevel 枚举常量,该常量代表分类标签源自位置的级别。Returns or sets a ChartCategoryLabelLevel enumeration constant referring to the level of where the category labels are being sourced from. 读/写。Read/Write.

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

chartType

表示图表的类型。Represents the type of the chart. 有关详细信息, 请参阅 ChartType。See Excel.ChartType for details.

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

dataLabels

表示图表上的数据标签。Represents the datalabels on the chart.

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

displayBlanksAs

返回或设置图表上的空白单元格的绘制方式。Returns or sets the way that blank cells are plotted on a chart. 读/写。Read/Write.

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

format

封装图表区域的格式属性。Encapsulates the format properties for the chart area.

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

height

表示 chart 对象的高度,以磅值表示。Represents the height, in points, of the chart object.

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

id

图表的唯一 ID。The unique id of chart. 只读。Read-only.

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

left

从图表左侧到工作表原点的距离,以磅值表示。The distance, in points, from the left side of the chart to the worksheet origin.

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

legend

表示图表的图例。Represents the legend for the chart.

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

name

表示 chart 对象的名称。Represents the name of a chart object.

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

pivotOptions

封装数据透视图表的选项。Encapsulates the options for a pivot chart.

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

plotArea

表示图表的绘制区域。Represents the plotArea for the chart.

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

plotBy

返回或设置图表上的列或行用作数据系列的方式。Returns or sets the way columns or rows are used as data series on the chart. 读/写。Read/Write.

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

plotVisibleOnly

如果仅绘制可见单元格,则为 True。True if only visible cells are plotted. 如果绘制可见单元格和隐藏单元格,则为 False。False if both visible and hidden cells are plotted. 读/写。Read/Write.

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

series

表示单个系列或图表中的系列集合。Represents either a single series or collection of series in the chart.

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

seriesNameLevel

返回或设置 ChartSeriesNameLevel 枚举常量,该常量代表系列名称源自位置的级别。Returns or sets a ChartSeriesNameLevel enumeration constant referring to the level of where the series names are being sourced from. 读/写。Read/Write.

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

showAllFieldButtons

表示是否在数据透视图上显示所有字段按钮。Represents whether to display all field buttons on a PivotChart.

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

showDataLabelsOverMaximum

表示当值大于数值轴上的最大值时是否显示数据标签。Represents whether to show the data labels when the value is greater than the maximum value on the value axis. 如果数值轴变为小于数据点的大小, 则可以使用此属性来设置是否显示数据标签。If value axis became smaller than the size of data points, you can use this property to set whether to show the data labels. 该属性只适用于二维图表。This property applies to 2-D charts only.

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

style

返回或设置图表的图表样式。Returns or sets the chart style for the chart. 读/写。Read/Write.

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

title

表示指定图表的标题,包括标题的文本、可见性、位置和格式。Represents the title of the specified chart, including the text, visibility, position, and formatting of the title.

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

top

表示从对象左边界至第 1 行顶部(在工作表上)或图表区域顶部(在图表上)的距离,以磅值表示。Represents the distance, in points, from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart).

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

width

表示 chart 对象的宽度,以磅值表示。Represents the width, in points, of the chart object.

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

worksheet

包含当前 chart 的 worksheet 对象。The worksheet containing the current chart.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

属性详细信息

$all

$all?: boolean;

属性值

boolean

axes

表示图表坐标轴。Represents chart axes.

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

axes?: Excel.Interfaces.ChartAxesLoadOptions;

属性值

categoryLabelLevel

返回或设置 ChartCategoryLabelLevel 枚举常量,该常量代表分类标签源自位置的级别。Returns or sets a ChartCategoryLabelLevel enumeration constant referring to the level of where the category labels are being sourced from. 读/写。Read/Write.

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

categoryLabelLevel?: boolean;

属性值

boolean

chartType

表示图表的类型。Represents the type of the chart. 有关详细信息, 请参阅 ChartType。See Excel.ChartType for details.

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

chartType?: boolean;

属性值

boolean

dataLabels

表示图表上的数据标签。Represents the datalabels on the chart.

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

dataLabels?: Excel.Interfaces.ChartDataLabelsLoadOptions;

属性值

displayBlanksAs

返回或设置图表上的空白单元格的绘制方式。Returns or sets the way that blank cells are plotted on a chart. 读/写。Read/Write.

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

displayBlanksAs?: boolean;

属性值

boolean

format

封装图表区域的格式属性。Encapsulates the format properties for the chart area.

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

format?: Excel.Interfaces.ChartAreaFormatLoadOptions;

属性值

height

表示 chart 对象的高度,以磅值表示。Represents the height, in points, of the chart object.

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

height?: boolean;

属性值

boolean

id

图表的唯一 ID。The unique id of chart. 只读。Read-only.

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

id?: boolean;

属性值

boolean

left

从图表左侧到工作表原点的距离,以磅值表示。The distance, in points, from the left side of the chart to the worksheet origin.

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

left?: boolean;

属性值

boolean

legend

表示图表的图例。Represents the legend for the chart.

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

legend?: Excel.Interfaces.ChartLegendLoadOptions;

属性值

name

表示 chart 对象的名称。Represents the name of a chart object.

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

name?: boolean;

属性值

boolean

pivotOptions

封装数据透视图表的选项。Encapsulates the options for a pivot chart.

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

pivotOptions?: Excel.Interfaces.ChartPivotOptionsLoadOptions;

属性值

plotArea

表示图表的绘制区域。Represents the plotArea for the chart.

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

plotArea?: Excel.Interfaces.ChartPlotAreaLoadOptions;

属性值

plotBy

返回或设置图表上的列或行用作数据系列的方式。Returns or sets the way columns or rows are used as data series on the chart. 读/写。Read/Write.

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

plotBy?: boolean;

属性值

boolean

plotVisibleOnly

如果仅绘制可见单元格,则为 True。True if only visible cells are plotted. 如果绘制可见单元格和隐藏单元格,则为 False。False if both visible and hidden cells are plotted. 读/写。Read/Write.

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

plotVisibleOnly?: boolean;

属性值

boolean

series

表示单个系列或图表中的系列集合。Represents either a single series or collection of series in the chart.

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

series?: Excel.Interfaces.ChartSeriesCollectionLoadOptions;

属性值

seriesNameLevel

返回或设置 ChartSeriesNameLevel 枚举常量,该常量代表系列名称源自位置的级别。Returns or sets a ChartSeriesNameLevel enumeration constant referring to the level of where the series names are being sourced from. 读/写。Read/Write.

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

seriesNameLevel?: boolean;

属性值

boolean

showAllFieldButtons

表示是否在数据透视图上显示所有字段按钮。Represents whether to display all field buttons on a PivotChart.

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

showAllFieldButtons?: boolean;

属性值

boolean

showDataLabelsOverMaximum

表示当值大于数值轴上的最大值时是否显示数据标签。Represents whether to show the data labels when the value is greater than the maximum value on the value axis. 如果数值轴变为小于数据点的大小, 则可以使用此属性来设置是否显示数据标签。If value axis became smaller than the size of data points, you can use this property to set whether to show the data labels. 该属性只适用于二维图表。This property applies to 2-D charts only.

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

showDataLabelsOverMaximum?: boolean;

属性值

boolean

style

返回或设置图表的图表样式。Returns or sets the chart style for the chart. 读/写。Read/Write.

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

style?: boolean;

属性值

boolean

title

表示指定图表的标题,包括标题的文本、可见性、位置和格式。Represents the title of the specified chart, including the text, visibility, position, and formatting of the title.

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

title?: Excel.Interfaces.ChartTitleLoadOptions;

属性值

top

表示从对象左边界至第 1 行顶部(在工作表上)或图表区域顶部(在图表上)的距离,以磅值表示。Represents the distance, in points, from the top edge of the object to the top of row 1 (on a worksheet) or the top of the chart area (on a chart).

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

top?: boolean;

属性值

boolean

width

表示 chart 对象的宽度,以磅值表示。Represents the width, in points, of the chart object.

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

width?: boolean;

属性值

boolean

worksheet

包含当前 chart 的 worksheet 对象。The worksheet containing the current chart.

[API 集: ExcelApi 1.2][ API set: ExcelApi 1.2 ]

worksheet?: Excel.Interfaces.WorksheetLoadOptions;

属性值