Excel.Interfaces.ChartAxisData interface

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

属性

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 ]

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. 只读。Read-only.

[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. 只读。Read-only.

[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. 只读。Read-only.

[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. 只读。Read-only.

[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 ]

属性详细信息

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?: Excel.ChartTickLabelAlignment | "Center" | "Left" | "Right";

属性值

Excel.ChartTickLabelAlignment | "Center" | "Left" | "Right"

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?: Excel.ChartAxisGroup | "Primary" | "Secondary";

属性值

Excel.ChartAxisGroup | "Primary" | "Secondary"

baseTimeUnit

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

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

baseTimeUnit?: Excel.ChartAxisTimeUnit | "Days" | "Months" | "Years";

属性值

Excel.ChartAxisTimeUnit | "Days" | "Months" | "Years"

categoryType

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

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

categoryType?: Excel.ChartAxisCategoryType | "Automatic" | "TextAxis" | "DateAxis";

属性值

Excel.ChartAxisCategoryType | "Automatic" | "TextAxis" | "DateAxis"

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?: number;

属性值

number

displayUnit

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

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

displayUnit?: Excel.ChartAxisDisplayUnit | "None" | "Hundreds" | "Thousands" | "TenThousands" | "HundredThousands" | "Millions" | "TenMillions" | "HundredMillions" | "Billions" | "Trillions" | "Custom";

属性值

Excel.ChartAxisDisplayUnit | "None" | "Hundreds" | "Thousands" | "TenThousands" | "HundredThousands" | "Millions" | "TenMillions" | "HundredMillions" | "Billions" | "Trillions" | "Custom"

format

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

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

format?: Excel.Interfaces.ChartAxisFormatData;

属性值

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?: number;

属性值

number

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?: number;

属性值

number

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?: number;

属性值

number

majorGridlines

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

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

majorGridlines?: Excel.Interfaces.ChartGridlinesData;

属性值

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?: Excel.ChartAxisTickMark | "None" | "Cross" | "Inside" | "Outside";

属性值

Excel.ChartAxisTickMark | "None" | "Cross" | "Inside" | "Outside"

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?: Excel.ChartAxisTimeUnit | "Days" | "Months" | "Years";

属性值

Excel.ChartAxisTimeUnit | "Days" | "Months" | "Years"

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?: any;

属性值

any

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?: any;

属性值

any

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?: any;

属性值

any

minorGridlines

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

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

minorGridlines?: Excel.Interfaces.ChartGridlinesData;

属性值

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?: Excel.ChartAxisTickMark | "None" | "Cross" | "Inside" | "Outside";

属性值

Excel.ChartAxisTickMark | "None" | "Cross" | "Inside" | "Outside"

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?: Excel.ChartAxisTimeUnit | "Days" | "Months" | "Years";

属性值

Excel.ChartAxisTimeUnit | "Days" | "Months" | "Years"

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?: any;

属性值

any

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?: string;

属性值

string

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?: number;

属性值

number

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?: Excel.ChartAxisPosition | "Automatic" | "Maximum" | "Minimum" | "Custom";

属性值

Excel.ChartAxisPosition | "Automatic" | "Maximum" | "Minimum" | "Custom"

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?: number;

属性值

number

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?: Excel.ChartAxisScaleType | "Linear" | "Logarithmic";

属性值

Excel.ChartAxisScaleType | "Linear" | "Logarithmic"

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?: any;

属性值

any

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?: Excel.ChartAxisTickLabelPosition | "NextToAxis" | "High" | "Low" | "None";

属性值

Excel.ChartAxisTickLabelPosition | "NextToAxis" | "High" | "Low" | "None"

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?: any;

属性值

any

tickMarkSpacing

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

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

tickMarkSpacing?: number;

属性值

number

title

表示坐标轴标题。Represents the axis title. 只读。Read-only.

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

title?: Excel.Interfaces.ChartAxisTitleData;

属性值

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?: number;

属性值

number

type

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

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

type?: Excel.ChartAxisType | "Invalid" | "Category" | "Value" | "Series";

属性值

Excel.ChartAxisType | "Invalid" | "Category" | "Value" | "Series"

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?: number;

属性值

number