Hide and Show Gridlines in Excel

This guide provides a practical overview of Hide and Show Gridlines, including its main features, benefits, limitations, and important considerations.

Example of creating a gridless chart:

To display gridlines in the chart do the following:

1. Display grid lines in the chart:

Step 1: Click on the chart -> Design -> Add Chart Element -> GridLine -> click Primary Major Horizontal to display the horizontal grid lines:

After choosing the result:

Step 2: Click the chart -> Design -> Add Chart Element -> GridLine -> click Primary Major Vertical to display vertical grid lines:

If you want smaller grid lines, do the following:

+ Click on the chart -> Design -> Add Chart Element -> GridLine -> click Primary Minor Horizontal to display horizontal grid lines with small size:

+ Similar to the grid lines have small vertical dimensions. After choosing the result:

2. Edit the grid lines of the chart:

- Click on the grid of the chart -> Format -> Shape Styles -> choose the colors and effects for the grid of the chart in the section:

+ Shape Outline: Create color borders for the grid.

+ Shape Effects: Create effects for the grid.

- After modifying the grid lines the results are:

3. Hide the grid lines of the chart.

- Click on the chart -> Design -> Add Chart Element -> GridLine -> click again on the selected objects to display on the chart (as shown below, all Gridline objects are not displayed):

The above is a detailed guide on how to show grid lines in a chart in Excel 2013.

Good luck!