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

TypeScript

$all?: boolean;

Property Value

boolean

allowOverflow

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

TypeScript

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.

TypeScript

allowUnderflow?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

count

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

TypeScript

count?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

overflowValue

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

TypeScript

overflowValue?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

type

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

TypeScript

type?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

underflowValue

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

TypeScript

underflowValue?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

width

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

TypeScript

width?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]