Excel.Interfaces.ChartBinOptionsLoadOptions interface

Encapsulates the bin options for histogram charts and pareto charts.

Remarks

[ API set: ExcelApi 1.9 ]

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

allowOverflow

Specifies if bin overflow is enabled in a histogram chart or pareto chart.

allowUnderflow

Specifies if bin underflow is enabled in a histogram chart or pareto chart.

count

Specifies the bin count of a histogram chart or pareto chart.

overflowValue

Specifies the bin overflow value of a histogram chart or pareto chart.

type

Specifies the bin's type for a histogram chart or pareto chart.

underflowValue

Specifies the bin underflow value of a histogram chart or pareto chart.

width

Specifies the bin width value of a histogram chart or pareto chart.

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

allowOverflow

Specifies if bin overflow is enabled in a histogram chart or pareto chart.

allowOverflow?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

allowUnderflow

Specifies if bin underflow is enabled in a histogram chart or pareto chart.

allowUnderflow?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

count

Specifies the bin count of a histogram chart or pareto chart.

count?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

overflowValue

Specifies the bin overflow value of a histogram chart or pareto chart.

overflowValue?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

type

Specifies the bin's type for a histogram chart or pareto chart.

type?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

underflowValue

Specifies the bin underflow value of a histogram chart or pareto chart.

underflowValue?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

width

Specifies the bin width value of a histogram chart or pareto chart.

width?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]