Excel.Interfaces.ChartBinOptionsData interface

An interface describing the data returned by calling chartBinOptions.toJSON().

Properties

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

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?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.9 ]

overflowValue

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

overflowValue?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.9 ]

type

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

type?: Excel.ChartBinType | "Category" | "Auto" | "BinWidth" | "BinCount";

Property Value

Excel.ChartBinType | "Category" | "Auto" | "BinWidth" | "BinCount"

Remarks

[ API set: ExcelApi 1.9 ]

underflowValue

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

underflowValue?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.9 ]

width

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

width?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.9 ]