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