Excel.Interfaces.ChartBinOptionsLoadOptions interface

Package:

excel

Encapsulates the bin options for histogram charts and pareto charts.

Remarks

[ API set: ExcelApi 1.9 ]

Properties

$all	Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: 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 LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: 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 ]