BoxEdgeMethod Property

The BoxEdgeMethod property returns or sets the method for specifying the edges in a box plot. Returns a Long.

Syntax

object.BoxEdgeMethod

object.BoxEdgeMethod = BoxEdgeMethod

 

Parameter Type Description
BoxEdgeMethod grfBoxEdgeMethod required, specifies which statistical values are used for the box extents

 

Remarks

Some box edge methods have options:

  • grfBEMPercentile - Use BoxLowerPercentile and BoxUpperPercentile to specify the percentiles. Only one property needs to be specified, and the other is automatically updated.

  • grfBEMConfidenceLevel - Use BoxConfidenLevel to specify the confidence level.

  • grfBEMStdDev - Use BoxStdVarCount to specify the number of standard deviations.

  • grfBEMStdError Use BoxStdVarCount to specify the number of standard errors.

 

Example 1

This example shows how to return the box edge method.

Debug.Print AutoBoxPlot.BoxEdgeMethod

Example 2

This example shows how to set box edges to the quartiles.

AutoBoxPlot.BoxEdgeMethod = grfBEMQuartiles

 

Used by: AutoBoxPlot object