Hide and show gridlines in Excel
The following article guides you in detail how to show gridlines in charts in Excel 2013.

Example of creating a gridless chart:
Hide and show gridlines in Excel Picture 2
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:
Hide and show gridlines in Excel Picture 3
After choosing the result:
Hide and show gridlines in Excel Picture 4
Step 2: Click the chart -> Design -> Add Chart Element -> GridLine -> click Primary Major Vertical to display vertical grid lines:
Hide and show gridlines in Excel Picture 5
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:
Hide and show gridlines in Excel Picture 6
+ Similar to the grid lines have small vertical dimensions. After choosing the result:
Hide and show gridlines in Excel Picture 7
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:
Hide and show gridlines in Excel Picture 8
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) :
Hide and show gridlines in Excel Picture 9
The above is a detailed guide on how to show grid lines in a chart in Excel 2013.
Good luck!
You should read it
- Instructions on how to delete gridlines in Excel
- How to hide and hide sheets in Excel and show them again
- Hide / show the Formula Bar in Excel
- How to hide, show notes in tables on Excel
- How to hide and show Sheet in Excel
- Types of data hiding in Excel - Part end: Hide Excel Files
- How to hide formulas in Excel
- Types of data hiding in Excel - Hide pictures, graphs, rows, columns
- How to display sheet tabs in Excel
- How to hide and show the Ribbon toolbar in Word and Excel
- Hide and show chart labels in Excel
- How to hide and show the rows and columns in Excel is extremely simple.