Excel.Interfaces.ChartAxisLoadOptions interface

代表图表中的单个坐标轴。Represents a single axis in a chart.

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

属性

$all
alignment

表示指定轴刻度线标签的对齐方式。Represents the alignment for the specified axis tick label. 有关详细信息, 请参阅 ChartTextHorizontalAlignment。See Excel.ChartTextHorizontalAlignment for detail.

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

axisGroup

返回或设置指定轴的组。Represents the group for the specified axis. 有关详细信息, 请参阅 ChartAxisGroup。See Excel.ChartAxisGroup for details. 只读。Read-only.

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

baseTimeUnit

返回或设置指定分类轴的基本单位。Returns or sets the base unit for the specified category axis.

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

categoryType

返回或设置分类轴类型。Returns or sets the category axis type.

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

crosses

[被保留以用于与现有第一方解决方案]的后端兼容。[DEPRECATED; kept for back-compat with existing first-party solutions]. Position改用。Please use Position instead. 表示两轴交叉处的特定轴。Represents the specified axis where the other axis crosses. 有关详细信息, 请参阅 ChartAxisPosition。See Excel.ChartAxisPosition for details.

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

crossesAt

[被保留以用于与现有第一方解决方案]的后端兼容。[DEPRECATED; kept for back-compat with existing first-party solutions]. PositionAt改用。Please use PositionAt instead. 表示两轴交叉处的特定轴。Represents the specified axis where the other axis crosses at. 只读。Read Only. 设置此属性应使用 SetCrossesAt(double) 方法。Set to this property should use SetCrossesAt(double) method.

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

customDisplayUnit

标识自定义轴显示单位值。Represents the custom axis display unit value. 只读。Read-only. 要设置此属性,请使用 SetCustomDisplayUnit(double) 方法。To set this property, please use the SetCustomDisplayUnit(double) method.

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

displayUnit

表示轴显示单位。Represents the axis display unit. 有关详细信息, 请参阅 ChartAxisDisplayUnit。See Excel.ChartAxisDisplayUnit for details.

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

format

表示 chart 对象的格式,包括线条和字体格式。Represents the formatting of a chart object, which includes line and font formatting.

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

height

表示图表轴的高度,以磅为单位。Represents the height, in points, of the chart axis. 如果轴不可见, 则为 Null。Null if the axis is not visible. 只读。Read-only.

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

isBetweenCategories

表示数值轴是否与分类之间的分类轴交叉。Represents whether value axis crosses the category axis between categories.

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

left

表示轴的左边缘到图表区域左侧的距离,以磅为单位。Represents the distance, in points, from the left edge of the axis to the left of chart area. 如果轴不可见, 则为 Null。Null if the axis is not visible. 只读。Read-only.

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

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 ]

logBase

表示使用对数刻度时对数的底数。Represents the base of the logarithm when using logarithmic scales.

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

majorGridlines

返回一个表示指定坐标轴的主要网格线的网格线对象。Returns a Gridlines object that represents the major gridlines for the specified axis.

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

majorTickMark

表示特定轴的主要刻度线类型。Represents the type of major tick mark for the specified axis. 有关详细信息, 请参阅 ChartAxisTickMark。See Excel.ChartAxisTickMark for details.

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

majorTimeUnitScale

返回或设置当 CategoryType 属性设为 TimeScale 时分类轴的主要单位刻度值。Returns or sets the major unit scale value for the category axis when the CategoryType property is set to TimeScale.

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

majorUnit

表示两个主要刻度标记之间的间隔。Represents the interval between two major tick marks. 可以设置为数字值或空字符串。Can be set to a numeric value or an empty string. 返回的值始终为数字。The returned value is always a number.

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

maximum

表示数值轴上的最大值。Represents the maximum value on the value axis. 可以设置为数字值或空字符串(对于自动坐标轴值)。Can be set to a numeric value or an empty string (for automatic axis values). 返回的值始终为数字。The returned value is always a number.

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

minimum

表示数值轴上的最小值。Represents the minimum value on the value axis. 可以设置为数字值或空字符串(对于自动坐标轴值)。Can be set to a numeric value or an empty string (for automatic axis values). 返回的值始终为数字。The returned value is always a number.

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

minorGridlines

返回一个表示指定坐标轴的次要网格线的网格线对象。Returns a Gridlines object that represents the minor gridlines for the specified axis.

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

minorTickMark

表示指定轴的次要刻度线类型。Represents the type of minor tick mark for the specified axis. 有关详细信息, 请参阅 ChartAxisTickMark。See Excel.ChartAxisTickMark for details.

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

minorTimeUnitScale

返回或设置当 CategoryType 属性设为 TimeScale 时分类轴的次要单位刻度值。Returns or sets the minor unit scale value for the category axis when the CategoryType property is set to TimeScale.

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

minorUnit

表示两个次要刻度标记之间的间隔。Represents the interval between two minor tick marks. 可以设置为数字值或空字符串(对于自动坐标轴值)。Can be set to a numeric value or an empty string (for automatic axis values). 返回的值始终为数字。The returned value is always a number.

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

multiLevel

表示是否为多级轴。Represents whether an axis is multilevel or not.

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

numberFormat

表示轴刻度线标签的格式代码。Represents the format code for the axis tick label.

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

offset

表示不同标签级别之间的距离以及一级标签和轴线之间的距离。Represents the distance between the levels of labels, and the distance between the first level and the axis line. 此值应该是 0 到 1000 之间的整数。The value should be an integer from 0 to 1000.

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

position

表示两轴交叉的特定轴位置。Represents the specified axis position where the other axis crosses. 有关详细信息, 请参阅 ChartAxisPosition。See Excel.ChartAxisPosition for details.

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

positionAt

表示两轴交叉的特定轴位置。Represents the specified axis position where the other axis crosses at. 应使用 SetPositionAt(double) 方法设置此属性。You should use the SetPositionAt(double) method to set this property.

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

reversePlotOrder

表示 Microsoft Excel 是否按照最后一个到第一个的顺序绘制数据点。Represents whether Microsoft Excel plots data points from last to first.

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

scaleType

表示数值轴刻度类型。Represents the value axis scale type. 有关详细信息, 请参阅 ChartAxisScaleType。See Excel.ChartAxisScaleType for details.

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

showDisplayUnitLabel

表示轴显示单位标签是否可见。Represents whether the axis display unit label is visible.

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

textOrientation

表示轴刻度线标签的文本方向。Represents the text orientation of the axis tick 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 ]

tickLabelPosition

表示特定轴上的刻度线标签位置。Represents the position of tick-mark labels on the specified axis. 有关详细信息, 请参阅 ChartAxisTickLabelPosition。See Excel.ChartAxisTickLabelPosition for details.

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

tickLabelSpacing

表示刻度线标签之间的分类或系列数。Represents the number of categories or series between tick-mark labels. 可以是 1 到 31999 的值或空字符串(自动设置)。Can be a value from 1 through 31999 or an empty string for automatic setting. 返回的值始终为数字。The returned value is always a number.

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

tickMarkSpacing

表示刻度线之间的分类或系列数。Represents the number of categories or series between tick marks.

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

title

表示坐标轴标题。Represents the axis title.

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

top

表示轴的上边缘到图表区域顶部的距离,以磅为单位。Represents the distance, in points, from the top edge of the axis to the top of chart area. 如果轴不可见, 则为 Null。Null if the axis is not visible. 只读。Read-only.

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

type

表示轴类型。Represents the axis type. 有关详细信息, 请参阅 ChartAxisType。See Excel.ChartAxisType for details.

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

visible

该布尔值表示轴的可见性。A boolean value represents the visibility of the axis.

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

width

表示图表轴的宽度,以磅为单位。Represents the width, in points, of the chart axis. 如果轴不可见, 则为 Null。Null if the axis is not visible. 只读。Read-only.

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

属性详细信息

$all

$all?: boolean;

属性值

boolean

alignment

表示指定轴刻度线标签的对齐方式。Represents the alignment for the specified axis tick label. 有关详细信息, 请参阅 ChartTextHorizontalAlignment。See Excel.ChartTextHorizontalAlignment for detail.

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

alignment?: boolean;

属性值

boolean

axisGroup

返回或设置指定轴的组。Represents the group for the specified axis. 有关详细信息, 请参阅 ChartAxisGroup。See Excel.ChartAxisGroup for details. 只读。Read-only.

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

axisGroup?: boolean;

属性值

boolean

baseTimeUnit

返回或设置指定分类轴的基本单位。Returns or sets the base unit for the specified category axis.

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

baseTimeUnit?: boolean;

属性值

boolean

categoryType

返回或设置分类轴类型。Returns or sets the category axis type.

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

categoryType?: boolean;

属性值

boolean

crosses

[被保留以用于与现有第一方解决方案]的后端兼容。[DEPRECATED; kept for back-compat with existing first-party solutions]. Position改用。Please use Position instead. 表示两轴交叉处的特定轴。Represents the specified axis where the other axis crosses. 有关详细信息, 请参阅 ChartAxisPosition。See Excel.ChartAxisPosition for details.

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

crosses?: boolean;

属性值

boolean

crossesAt

[被保留以用于与现有第一方解决方案]的后端兼容。[DEPRECATED; kept for back-compat with existing first-party solutions]. PositionAt改用。Please use PositionAt instead. 表示两轴交叉处的特定轴。Represents the specified axis where the other axis crosses at. 只读。Read Only. 设置此属性应使用 SetCrossesAt(double) 方法。Set to this property should use SetCrossesAt(double) method.

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

crossesAt?: boolean;

属性值

boolean

customDisplayUnit

标识自定义轴显示单位值。Represents the custom axis display unit value. 只读。Read-only. 要设置此属性,请使用 SetCustomDisplayUnit(double) 方法。To set this property, please use the SetCustomDisplayUnit(double) method.

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

customDisplayUnit?: boolean;

属性值

boolean

displayUnit

表示轴显示单位。Represents the axis display unit. 有关详细信息, 请参阅 ChartAxisDisplayUnit。See Excel.ChartAxisDisplayUnit for details.

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

displayUnit?: boolean;

属性值

boolean

format

表示 chart 对象的格式,包括线条和字体格式。Represents the formatting of a chart object, which includes line and font formatting.

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

format?: Excel.Interfaces.ChartAxisFormatLoadOptions;

属性值

height

表示图表轴的高度,以磅为单位。Represents the height, in points, of the chart axis. 如果轴不可见, 则为 Null。Null if the axis is not visible. 只读。Read-only.

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

height?: boolean;

属性值

boolean

isBetweenCategories

表示数值轴是否与分类之间的分类轴交叉。Represents whether value axis crosses the category axis between categories.

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

isBetweenCategories?: boolean;

属性值

boolean

left

表示轴的左边缘到图表区域左侧的距离,以磅为单位。Represents the distance, in points, from the left edge of the axis to the left of chart area. 如果轴不可见, 则为 Null。Null if the axis is not visible. 只读。Read-only.

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

left?: boolean;

属性值

boolean

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

logBase

表示使用对数刻度时对数的底数。Represents the base of the logarithm when using logarithmic scales.

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

logBase?: boolean;

属性值

boolean

majorGridlines

返回一个表示指定坐标轴的主要网格线的网格线对象。Returns a Gridlines object that represents the major gridlines for the specified axis.

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

majorGridlines?: Excel.Interfaces.ChartGridlinesLoadOptions;

属性值

majorTickMark

表示特定轴的主要刻度线类型。Represents the type of major tick mark for the specified axis. 有关详细信息, 请参阅 ChartAxisTickMark。See Excel.ChartAxisTickMark for details.

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

majorTickMark?: boolean;

属性值

boolean

majorTimeUnitScale

返回或设置当 CategoryType 属性设为 TimeScale 时分类轴的主要单位刻度值。Returns or sets the major unit scale value for the category axis when the CategoryType property is set to TimeScale.

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

majorTimeUnitScale?: boolean;

属性值

boolean

majorUnit

表示两个主要刻度标记之间的间隔。Represents the interval between two major tick marks. 可以设置为数字值或空字符串。Can be set to a numeric value or an empty string. 返回的值始终为数字。The returned value is always a number.

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

majorUnit?: boolean;

属性值

boolean

maximum

表示数值轴上的最大值。Represents the maximum value on the value axis. 可以设置为数字值或空字符串(对于自动坐标轴值)。Can be set to a numeric value or an empty string (for automatic axis values). 返回的值始终为数字。The returned value is always a number.

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

maximum?: boolean;

属性值

boolean

minimum

表示数值轴上的最小值。Represents the minimum value on the value axis. 可以设置为数字值或空字符串(对于自动坐标轴值)。Can be set to a numeric value or an empty string (for automatic axis values). 返回的值始终为数字。The returned value is always a number.

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

minimum?: boolean;

属性值

boolean

minorGridlines

返回一个表示指定坐标轴的次要网格线的网格线对象。Returns a Gridlines object that represents the minor gridlines for the specified axis.

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

minorGridlines?: Excel.Interfaces.ChartGridlinesLoadOptions;

属性值

minorTickMark

表示指定轴的次要刻度线类型。Represents the type of minor tick mark for the specified axis. 有关详细信息, 请参阅 ChartAxisTickMark。See Excel.ChartAxisTickMark for details.

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

minorTickMark?: boolean;

属性值

boolean

minorTimeUnitScale

返回或设置当 CategoryType 属性设为 TimeScale 时分类轴的次要单位刻度值。Returns or sets the minor unit scale value for the category axis when the CategoryType property is set to TimeScale.

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

minorTimeUnitScale?: boolean;

属性值

boolean

minorUnit

表示两个次要刻度标记之间的间隔。Represents the interval between two minor tick marks. 可以设置为数字值或空字符串(对于自动坐标轴值)。Can be set to a numeric value or an empty string (for automatic axis values). 返回的值始终为数字。The returned value is always a number.

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

minorUnit?: boolean;

属性值

boolean

multiLevel

表示是否为多级轴。Represents whether an axis is multilevel or not.

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

multiLevel?: boolean;

属性值

boolean

numberFormat

表示轴刻度线标签的格式代码。Represents the format code for the axis tick label.

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

numberFormat?: boolean;

属性值

boolean

offset

表示不同标签级别之间的距离以及一级标签和轴线之间的距离。Represents the distance between the levels of labels, and the distance between the first level and the axis line. 此值应该是 0 到 1000 之间的整数。The value should be an integer from 0 to 1000.

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

offset?: boolean;

属性值

boolean

position

表示两轴交叉的特定轴位置。Represents the specified axis position where the other axis crosses. 有关详细信息, 请参阅 ChartAxisPosition。See Excel.ChartAxisPosition for details.

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

position?: boolean;

属性值

boolean

positionAt

表示两轴交叉的特定轴位置。Represents the specified axis position where the other axis crosses at. 应使用 SetPositionAt(double) 方法设置此属性。You should use the SetPositionAt(double) method to set this property.

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

positionAt?: boolean;

属性值

boolean

reversePlotOrder

表示 Microsoft Excel 是否按照最后一个到第一个的顺序绘制数据点。Represents whether Microsoft Excel plots data points from last to first.

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

reversePlotOrder?: boolean;

属性值

boolean

scaleType

表示数值轴刻度类型。Represents the value axis scale type. 有关详细信息, 请参阅 ChartAxisScaleType。See Excel.ChartAxisScaleType for details.

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

scaleType?: boolean;

属性值

boolean

showDisplayUnitLabel

表示轴显示单位标签是否可见。Represents whether the axis display unit label is visible.

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

showDisplayUnitLabel?: boolean;

属性值

boolean

textOrientation

表示轴刻度线标签的文本方向。Represents the text orientation of the axis tick 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

tickLabelPosition

表示特定轴上的刻度线标签位置。Represents the position of tick-mark labels on the specified axis. 有关详细信息, 请参阅 ChartAxisTickLabelPosition。See Excel.ChartAxisTickLabelPosition for details.

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

tickLabelPosition?: boolean;

属性值

boolean

tickLabelSpacing

表示刻度线标签之间的分类或系列数。Represents the number of categories or series between tick-mark labels. 可以是 1 到 31999 的值或空字符串(自动设置)。Can be a value from 1 through 31999 or an empty string for automatic setting. 返回的值始终为数字。The returned value is always a number.

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

tickLabelSpacing?: boolean;

属性值

boolean

tickMarkSpacing

表示刻度线之间的分类或系列数。Represents the number of categories or series between tick marks.

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

tickMarkSpacing?: boolean;

属性值

boolean

title

表示坐标轴标题。Represents the axis title.

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

title?: Excel.Interfaces.ChartAxisTitleLoadOptions;

属性值

top

表示轴的上边缘到图表区域顶部的距离,以磅为单位。Represents the distance, in points, from the top edge of the axis to the top of chart area. 如果轴不可见, 则为 Null。Null if the axis is not visible. 只读。Read-only.

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

top?: boolean;

属性值

boolean

type

表示轴类型。Represents the axis type. 有关详细信息, 请参阅 ChartAxisType。See Excel.ChartAxisType for details.

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

type?: boolean;

属性值

boolean

visible

该布尔值表示轴的可见性。A boolean value represents the visibility of the axis.

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

visible?: boolean;

属性值

boolean

width

表示图表轴的宽度,以磅为单位。Represents the width, in points, of the chart axis. 如果轴不可见, 则为 Null。Null if the axis is not visible. 只读。Read-only.

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

width?: boolean;

属性值

boolean