Excel.Interfaces.ChartAxisLoadOptions interface

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

Specifies the alignment for the specified axis tick label. See Excel.ChartTextHorizontalAlignment for detail.

alignment?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

Specifies the group for the specified axis. See Excel.ChartAxisGroup for details.

axisGroup?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the base unit for the specified category axis.

baseTimeUnit?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the category axis type.

categoryType?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the custom axis display unit value. To set this property, please use the SetCustomDisplayUnit(double) method.

customDisplayUnit?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Represents the axis display unit. See Excel.ChartAxisDisplayUnit for details.

displayUnit?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Represents the formatting of a chart object, which includes line and font formatting.

format?: Excel.Interfaces.ChartAxisFormatLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Specifies the height, in points, of the chart axis. Returns null if the axis is not visible.

height?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies if the value axis crosses the category axis between categories.

isBetweenCategories?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

Specifies the distance, in points, from the left edge of the axis to the left of chart area. Returns null if the axis is not visible.

left?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the base of the logarithm when using logarithmic scales.

logBase?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Returns an object that represents the major gridlines for the specified axis.

majorGridlines?: Excel.Interfaces.ChartGridlinesLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Specifies the type of major tick mark for the specified axis. See Excel.ChartAxisTickMark for details.

majorTickMark?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the major unit scale value for the category axis when the categoryType property is set to dateAxis.

majorTimeUnitScale?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

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.

majorUnit?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

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.

maximum?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

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.

minimum?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Returns an object that represents the minor gridlines for the specified axis.

minorGridlines?: Excel.Interfaces.ChartGridlinesLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Specifies the type of minor tick mark for the specified axis. See Excel.ChartAxisTickMark for details.

minorTickMark?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the minor unit scale value for the category axis when the categoryType property is set to dateAxis.

minorTimeUnitScale?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

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.

minorUnit?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Specifies if an axis is multilevel.

multiLevel?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

Specifies the format code for the axis tick label.

numberFormat?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

Specifies the distance between the levels of labels, and the distance between the first level and the axis line. The value should be an integer from 0 to 1000.

offset?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

Specifies the specified axis position where the other axis crosses. See Excel.ChartAxisPosition for details.

position?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

Specifies the axis position where the other axis crosses. You should use the SetPositionAt(double) method to set this property.

positionAt?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

Specifies if Excel plots data points from last to first.

reversePlotOrder?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the value axis scale type. See Excel.ChartAxisScaleType for details.

scaleType?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies if the axis display unit label is visible.

showDisplayUnitLabel?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the angle to which the text is oriented for the chart axis tick label. The value should either be an integer from -90 to 90 or the integer 180 for vertically-oriented text.

textOrientation?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.8 ]

Specifies the position of tick-mark labels on the specified axis. See Excel.ChartAxisTickLabelPosition for details.

tickLabelPosition?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the number of categories or series between tick-mark labels. Can be a value from 1 through 31999 or an empty string for automatic setting. The returned value is always a number.

tickLabelSpacing?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the number of categories or series between tick marks.

tickMarkSpacing?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Represents the axis title.

title?: Excel.Interfaces.ChartAxisTitleLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

Specifies the distance, in points, from the top edge of the axis to the top of chart area. Returns null if the axis is not visible.

top?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the axis type. See Excel.ChartAxisType for details.

type?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies if the axis is visible.

visible?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]

Specifies the width, in points, of the chart axis. Returns null if the axis is not visible.

width?: boolean;

Property Value

Remarks

[ API set: ExcelApi 1.7 ]