Excel.Interfaces.ChartBoxwhiskerOptionsLoadOptions interface

Represents the properties of a box and whisker chart.

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

quartileCalculation

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

showInnerPoints

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

showMeanLine

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

showMeanMarker

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

showOutlierPoints

Specifies if outlier points are shown in a box and whisker 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

quartileCalculation

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

quartileCalculation?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

showInnerPoints

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

showInnerPoints?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

showMeanLine

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

showMeanLine?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

showMeanMarker

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

showMeanMarker?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

showOutlierPoints

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

showOutlierPoints?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]