Show Gridlines in a Current Default Chart

You can also show alternating bands of color in the chart background that correspond to your axis gridlines.

You can change the scale for the major and minor gridlines using the Axis Range property.

Procedure

Select the Y-axis or the X-axis of the chart.
To show alternating bands of color as your chart background, do the following:
1. In the Properties pane, double-click the Gridlines property.
2. Select the Show alternating color bands check box.
3. Set the color and transparency of the first and second colors.
To show major gridlines as your chart background, do the following:
1. In the Properties pane, double-click the Gridlines property.
2. Select the Show major gridlines check box.
3. Set the color, style, and weight of the major gridlines.
4. If you are working with a gauge chart, specify the length of the gridline.
To show minor gridlines as your chart background, do the following:
1. In the Properties pane, double-click the Minor gridlines property.
2. Select the Show minor gridlines check box.
3. Set the color, style, and weight of the minor gridlines.
4. If you are working with a gauge chart, specify the length of the gridline.
5. To specify by how many minor intervals to divide the major intervals, in the Properties pane, type a number in the Number of Minor Intervals property.