Microsoft Office Tutorials and References
In Depth Information
Figure 21-12. Axis units and scale
.MajorUnit = 1
.MaximumScale = 5
End With
will cause the axis to appear as on the left in Figure 21-12 . On the other hand, the code:
With ActiveChart.Axes(xlValue, xlPrimary)
.MajorUnit = 5
.MaximumScale = 3
End With
results in the axis shown on the right in Figure 21-12 .
Figure 21-12. Axis units and scale
21.6.11 ReversePlotOrder Property
This read/write Boolean property can be set to True to have Excel reverse the direction of an axis
(although the name is not very descriptive of the function). For instance, if the active chart is the
chart in Figure 21-13 , then the code:
ActiveChart.Axes(xlValue, xlPrimary).ReversePlotOrder = True
changes this chart to the one in Figure 21-14 , where the primary axis data is plotted from the top
down (so to speak).
Figure 21-13. Illustrating ReversePlotOrder (before)
 
 
 
 
 
Search JabSto ::




Custom Search