Axis.MajorUnitScale Property
Returns or sets the major unit scale value for the category axis when the CategoryType property is set to xlTimeScale. Read/write [XlTimeUnit#SameCHM].
Namespace: Microsoft.Office.Interop.PowerPoint
Assembly: Microsoft.Office.Interop.PowerPoint (in Microsoft.Office.Interop.PowerPoint.dll)
Syntax
'Declaration
Property MajorUnitScale As XlTimeUnit
Get
Set
'Usage
Dim instance As Axis
Dim value As XlTimeUnit
value = instance.MajorUnitScale
instance.MajorUnitScale = value
XlTimeUnit MajorUnitScale { get; set; }
Property Value
Type: Microsoft.Office.Interop.PowerPoint.XlTimeUnit
Remarks
MajorUnitScale can be one of these XlTimeUnit constants. |
xlMonths |
xlDays |
xlYears |
Examples
This example sets the category axis on the first chart in the active document to use a time scale and sets the major and minor units.
With ActivePresentation.Slides(1).Shapes(1)
If .HasChart Then
With .Chart.Axes(xlCategory)
.CategoryType = xlTimeScale
.MajorUnit = 5
.MajorUnitScale= xlDays
.MinorUnit = 1
.MinorUnitScale = xlDays
End With
End If
End With