Adding Chart Gridlines

You can change chart options to add gridlines to a chart. Gridlines are horizontal and vertical lines you can add to help the reader determine data point values in a chart. There are two types of gridlines: major and minor. Major gridlines occur at each value on an axis, while minor gridlines occur between values on an axis. Use gridlines sparingly and only when they improve the readability of a chart.

Add Gridlines

Select a chart to which you want to add gridlines.

Click the Chart menu, and then click Chart Options.

Click the Gridlines tab.

Select the type of gridlines you want for the x-axis (vertical) and y-axis (horizontal).

Click OK.