How to Insert Minor & Major Grid Lines in Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

Adding grid lines to Microsoft Excel charts helps to recognize data values by making it easier to line up points on the graph with the bottom left side of the scale. Major grid lines are bolder lines that distinguish scale milestones, such as increments of 5 or 100, depending on the scale of your chart. Minor grid lines fill in the gaps with lighter lines and represent smaller units, such as increments of 1. Excel allows you to add major and minor grid lines simultaneously, which may be vertical, horizontal or both.

Advertisement

Step 1

Open your spreadsheet chart in Microsoft Excel.

Video of the Day

Step 2

Click the chart to enable the Chart Tools at the top of the window.

Step 3

Click "Layout" tab in the Chart Tools menu group.

Advertisement

Step 4

Click "Gridlines" from the Axes group. Point to either "Primary Horizontal Gridlines" or "Primary Vertical Gridlines" and click "Major & Minor Gridlines" to add either horizontal or vertical lines, respectively. To add vertical and horizontal grid lines, perform the procedure for both axes.

Advertisement

Video of the Day

Advertisement

Advertisement

references