GroupingType Property

       

Returns or sets a ChartAxisGroupingEnum constant that represents whether or not the items on a chart axis are grouped, and if so, whether the grouping was done automatically. Read/write.

ChartAxisGroupingEnum can be one of these ChartAxisGroupingEnum constants.
chAxisGroupingAuto The Chart control chooses the grouping unit and type.
chAxisGroupingManual You will use the GroupingUnitType and GroupingUnit properties to perform the grouping.
chAxisGroupingNone Do not group the axis.

expression.GroupingType

expression   Required. An expression that returns a ChAxis object.

Remarks

The Chart control automatically creates a time scale and groups on the category axis when the following conditions are true:

Example

This example disables time scaling on the category axis of the first chart in Chartspace1.

Sub DisableTimeScaling()

    Dim chConstants
    Dim axCategory

    Set chConstants = ChartSpace1.Constants

    ' Set a variable to the category axis.
    Set axCategory = ChartSpace1.Charts(0).Axes(chConstants.chAxisPositionTimescale)

    ' Disable time scaling on the category axis.
    axCategory.GroupingType = chConstants.chAxisGroupingNone

End Sub