GroupByCategory Property

The GroupByCategory property returns or sets the grouping option for grouped box plot to category or variable

Syntax

object.GroupByCategory

object.GroupByCategory = grfBoxColorMethod

 

Parameter Type Description
GroupByCategory Long required; True groups boxes by category, False groups boxes by variable

 

Example 1

This example shows how to set a box plot to group by variable

Box_WhiskerPlot_obj.DataInGroups = True

Box_WhiskerPlot_obj.GroupByCategory = False

Example 2

This example shows how to return the color column value.

Debug.Print BoxWhiskerPlot.GroupByCategory

 

Used by: AutoBoxPlot