Name

axis.CrossesAt [= setting]

Synopsis

For 2-D charts with Crosses set to xlAxisCrossesCustom, sets or returns the point on the axis where the other axis starts. For example, the following code moves the category axis up to 100,000 on the value axis:

Sub MoveCategoryAxisUp(  )
    Dim chrt As Chart, ax As Axis
    Set chrt = ActiveSheet
    Set ax = chrt.Axes(xlValue, xlPrimary)
    ax.Crosses = xlAxisCrossesCustom
    ax.CrossesAt = 100000
End Sub

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial