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:
- 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