Excel.Interfaces.ChartAxisLoadOptions interface

Represents a single axis in a chart.

Remarks

[ API set: ExcelApi 1.1 ]

Properties

$all

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).

format

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

majorGridlines

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

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.

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.

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.

minorGridlines

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

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.

title

Represents the axis title.

Property Details

$all

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

boolean

format

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 ]

majorGridlines

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

majorGridlines?: Excel.Interfaces.ChartGridlinesLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

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.

majorUnit?: boolean;

Property Value

boolean

Remarks

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

maximum?: boolean;

Property Value

boolean

Remarks

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

minimum?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

minorGridlines

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

minorGridlines?: Excel.Interfaces.ChartGridlinesLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

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.

minorUnit?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

title

Represents the axis title.

title?: Excel.Interfaces.ChartAxisTitleLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]