GroupingType Property

  • Article

ChartAxisGroupingEnum

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:

  • The Chart control detects that the category information is a date.
  • The Chart control is bound to a PivotTable list, and the PivotTable list is not bound to an OLAP data source.

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

Applies to | ChAxis Object

See Also | GroupingTotalFunction Property | GroupingUnit Property | GroupingUnitType Property