Grid Spacing

Use the gridlines Spacing property to customize the grid spacing for an axis. Its IsDefault property allows the chart to space the grid automatically, drawing a gridline wherever there is annotation. These properties are located on the Axis/Gridlines Tab (Axes) on the Property Pages.