Remove Gridlines from Chart – Excel & Google Sheets

This tutorial will demonstrate how to remove gridlines on graphs in Excel and Google Sheets.

Remove Gridlines in Excel

Starting with your Graph

We’ll start with the below dataset. As you can see, the default for this graph shows horizontal gridlines.

Starting Graph to Remove Major Gridlines in Excel

 

Removing Gridlines

  1. Click on Graph
  2. Select + Sign in top right of graph
  3. Uncheck Gridlines

Uncheck Gridlines on Chart Graph in Excel

 

Final Graph without Gridlines

Your can see the final graph after removing the gridlines.

Final Graph without Gridlines in Chart Excel

 

Remove Gridlines in Google Sheets

Starting with your Data

We’ll use the same data in Google Sheets as we did in Excel

Starting Graph in Google Sheets to Remove Major Gridlines

 

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

Remove Gridlines in Google Sheets on Charts and Graphs

 

4. Uncheck Major Gridlines

Uncheck Major Gridlines in Graphs and Charts in Google Sheets

 

Final Graph without Gridlines

Final Graph without Gridlines on Chart in Google Sheets