Name

chart.WallsAndGridlines2D [= setting]

Synopsis

For 3-D charts, True draws gridlines in 2-D format. Default is False. Any difference in the gridline appearance is minor, as illustrated by the following code:

Sub ThreeDGridlines(  )
    Dim chrt As Chart
    Set chrt = Charts("New Chart")
    chrt.ChartType = xlSurface
    chrt.WallsAndGridlines2D = True
    chrt.Axes(xlCategory, xlPrimary).HasMajorGridlines = True
    chrt.Axes(xlValue, xlPrimary).HasMajorGridlines = True
    chrt.Axes(xlSeries, xlPrimary).HasMajorGridlines = True
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