Axis.MinorUnitScale Property
Returns or sets the minor 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 MinorUnitScale As XlTimeUnit
Get
Set
'Usage
Dim instance As Axis
Dim value As XlTimeUnit
value = instance.MinorUnitScale
instance.MinorUnitScale = value
XlTimeUnit MinorUnitScale { get; set; }
Property Value
Type: Microsoft.Office.Interop.PowerPoint.XlTimeUnit
Remarks
MinorUnitScale can be one of these XlTimeUnit constants. |
xlMonths |
xlDays |
xlYears |
Examples
This example sets the category axis 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