Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Axis.MinorUnitScale Property

Office 2007
Returns or sets the minor unit scale value for the category axis when the CategoryType property is set to xlTimeScale. Read/write XlTimeUnit.

Syntax

expression.MinorUnitScale

expression   A variable that represents an Axis object.

Remarks

XlTimeUnit can be one of these XlTimeUnit constants.
xlMonths
xlDays
xlYears

Example

This example sets the category axis to use a time scale and sets the major and minor units.

Visual Basic for Applications
With Charts(1).Axes(xlCategory)
    .CategoryType = xlTimeScale
    .MajorUnit = 5
    .MajorUnitScale = xlDays
    .MinorUnit = 1
    .MinorUnitScale = xlDays
End With



Community Additions

ADD
Show:
© 2015 Microsoft