Add Gridlines to Charts / Graphs – Excel & Google Sheets

This tutorial will demonstrate how to add gridlines to charts in Excel and Googles Sheets.

Add Gridlines to Charts / Graphs – Excel

Start with your Graph

In this tutorial, we will show you how to add gridlines to a chart. There are a few gridlines you can add: major horizontal and vertical and minor horizontal and vertical.

In bar charts, there are automatically horizontal major gridlines.

Adding Gridlines to Charts and Graphs in Excel

 

  1. Click on your graph
  2. Select the + Sign in the top right
  3. Select the error next to gridlines
  4. You will have the option to add different variations of gridlines to the graph

Adding Minor and Major Gridlines in Graphs Excel

Final Graph with Gridlines

You can see what the graph looks like adding minor horizontal gridlines as well as major horizontal gridlines.

Final Graph with Minor and Major Gridlines Excel

 

Add Gridlines to Charts / Graphs – Google Sheets

Add Gridlines

  1. Right click on the graph
  2. Select Gridlines and ticks
  3. Click Vertical Axis

Add Gridlines to Chart Graph Google Sheets

 

You can see the option to check major and minor gridlines as shown below.

Add Major and Minor Gridlines to Format Graph in Google Sheets

 

Final Graph with Gridlines

In this example, you can see what the graph looks like with the major and minor gridlines.

Final Graph and Chart with Major and Minor Gridlines in Google Sheets