ExcelScript.ChartBoxwhiskerOptions interface

Package:

ExcelScript

Represents the properties of a box and whisker chart.

Methods

getQuartileCalculation()	Specifies if the quartile calculation type of a box and whisker chart.
getShowInnerPoints()	Specifies if inner points are shown in a box and whisker chart.
getShowMeanLine()	Specifies if the mean line is shown in a box and whisker chart.
getShowMeanMarker()	Specifies if the mean marker is shown in a box and whisker chart.
getShowOutlierPoints()	Specifies if outlier points are shown in a box and whisker chart.
setQuartileCalculation(quartileCalculation)	Specifies if the quartile calculation type of a box and whisker chart.
setShowInnerPoints(showInnerPoints)	Specifies if inner points are shown in a box and whisker chart.
setShowMeanLine(showMeanLine)	Specifies if the mean line is shown in a box and whisker chart.
setShowMeanMarker(showMeanMarker)	Specifies if the mean marker is shown in a box and whisker chart.
setShowOutlierPoints(showOutlierPoints)	Specifies if outlier points are shown in a box and whisker chart.

Method Details

getQuartileCalculation()

Specifies if the quartile calculation type of a box and whisker chart.

getQuartileCalculation(): ChartBoxQuartileCalculation;

Returns

ExcelScript.ChartBoxQuartileCalculation

getShowInnerPoints()

Specifies if inner points are shown in a box and whisker chart.

getShowInnerPoints(): boolean;

Returns

boolean

getShowMeanLine()

Specifies if the mean line is shown in a box and whisker chart.

getShowMeanLine(): boolean;

Returns

boolean

getShowMeanMarker()

Specifies if the mean marker is shown in a box and whisker chart.

getShowMeanMarker(): boolean;

Returns

boolean

getShowOutlierPoints()

Specifies if outlier points are shown in a box and whisker chart.

getShowOutlierPoints(): boolean;

Returns

boolean

setQuartileCalculation(quartileCalculation)

Specifies if the quartile calculation type of a box and whisker chart.

setQuartileCalculation(
            quartileCalculation: ChartBoxQuartileCalculation
        ): void;

Parameters

quartileCalculation

ExcelScript.ChartBoxQuartileCalculation

Returns

void

setShowInnerPoints(showInnerPoints)

Specifies if inner points are shown in a box and whisker chart.

setShowInnerPoints(showInnerPoints: boolean): void;

Parameters

showInnerPoints

boolean

Returns

void

setShowMeanLine(showMeanLine)

Specifies if the mean line is shown in a box and whisker chart.

setShowMeanLine(showMeanLine: boolean): void;

Parameters

showMeanLine

boolean

Returns

void

setShowMeanMarker(showMeanMarker)

Specifies if the mean marker is shown in a box and whisker chart.

setShowMeanMarker(showMeanMarker: boolean): void;

Parameters

showMeanMarker

boolean

Returns

void

setShowOutlierPoints(showOutlierPoints)

Specifies if outlier points are shown in a box and whisker chart.

setShowOutlierPoints(showOutlierPoints: boolean): void;

Parameters

showOutlierPoints

boolean

Returns

void