When creating a chart in Google Sheets, you may want to add gridlines to your chart so the users better undertand the information contained in the chart. This tutorial will teach you how to add, remove and format gridlines on your Google Sheets chart.
Use the cursor to double-click on a blank area on your chart. Make sure to click on a blank area in the chart. The border around the entire chart will become highlighted, and the Chart Editor Panel will appear on the right side of the page.
Alternate method: Here is another way to get to the Chart Editor panel. When a blank area of the chart is selected, right click the mouse and Edit menu will appear. You can then select the Chart Style button and the Chart Editor panel will appear.
The Chart Editor Panel is where you will make changes to the chart title.
After you have selected your chart, the Chart Editor panel will appear on the right side of the page. Select the Customize tab, and then the options to edit the chart style will appear.
Click on the Gridlines and Ticks sub-menu on the Customize tab and you wil see the available Gridlines options for the chart type you have selected.
Click the Major Gridlines checkbox to enable the Major Gridlines on the chart.
Click the Minor Gridlines checkbox to enable the Minor Gridlines on the chart. These will appear between the Major Gridlines.
There are a couple of options to format your gridlines. The Gridlines formatting options are listed on the Gridlines and Ticks sub-menu.
You are able to format your chart gridlines in the following ways on a bar chart:
If you want to turn off your gridlines on your charts, you can follwo these steps:
Thanks for checking out this tutorial. If you need additional help, you can check out some of our other free Google Sheets Chart tutorials, or consider taking an Google Sheets class with one of our professional trainers.