How to Remove Gridlines in Excel Graph (5 Easy Methods)

While working with Microsoft Excel, we may use horizontal and vertical graph gridlines to enhance the content in a chart with axes simpler to interpret. Sometimes, when we insert a graph, it comes with gridlines by default, which may not be ideal for watching. In this article, we will demonstrate different methods to remove gridlines in Excel Graph.


Download Practice Workbook

You can download the workbook and practice with them.


What Are Gridlines in Excel Graph?

Gridlines are horizontal lines that span the chart plot and indicate axis divisions. These assists chart viewers to understand what value an unlabeled data point represents. It provides essential indications to the observer, especially for big or sophisticated charts.

Gridlines stretch throughout the plot area of the chart from any horizontal and vertical axes. In 3-D charts, depth gridlines can also be displayed. Gridlines correspond with primary and secondary tick markings on the directions when tick markers are presented for primary and secondary units.

You may use transverse and longitudinal chart gridlines to make the data in a chart with axes simpler to read. Gridlines stretch throughout the plot area of the chart from any horizontal and vertical axes.


5 Methods to Remove Gridlines in Excel Graph

Suppose, we have a set of data, and the dataset is a representation of a company’s monthly revenue. So, the dataset consists of the information of the revenue for each month in column C and 9 months in column B.

5 Methods to Remove Gridlines in Excel Graph

Now, I want to display the graphical representation of this dataset. For this, go to Insert > Chats. But we may not want to display the gridlines in excel graphs. So, we need to remove those gridlines from the graph. There are various ways to do that. Let’s demonstrate all the methods to remove gridlines from Excel Graph.

5 Methods to Remove Gridlines in Excel Graph


1. Use Delete Key or Delete Option to Remove Gridlines from Graph

We can simply remove the gridlines from the excel graph using the delete key or delete option. For this, we just need some simple clicks. Let’s follow the steps down.

STEPS:

  • Firstly, select any gridlines by clicking on one of them except the first gridline.
  • Secondly, right-click and click on the Delete context menu option.

  • Or, you can just select the Vertical (Value) Axis Major Gridlines to remove the vertical gridlines and press the Delete key from your keyboard.

Use Delete Key or Delete Option to Remove Gridlines from Graph 

  • And, if you want to remove the horizontal gridlines, click on the Horizontal (Value) Axis Major Gridlines and press the Delete key on the keyboard to erase them.

Use Delete Key or Delete Option to Remove Gridlines from Graph 

  • Finally, simply just following these steps will remove the gridlines from your excel graph.

Use Delete Key or Delete Option to Remove Gridlines from Graph 

Read More: How to Add Vertical Gridlines to Excel Chart (2 Easy Methods)


2. Clear Gridlines from a Graph by Quick Layout Option in Excel

Quick Layout allows us to easily modify the general layout of the chart by selecting one of the predefined layout choices. We can clear gridlines from excel graphs using the quick layout option. For this, we have to look at the procedures down.

STEPS:

  • First of all, click on the graph and go to the Chart Design from the ribbon.
  • Second, under the Chart Layouts category, click on the Quick Layout drop-down menu.
  • Thirdly, select the layout which does not contain the gridlines. So, we select Layout 4.

  • And, that’s it! This will disappear all the gridlines from the graph.

Read More: Excel Fix: Gridlines Disappear When Color Added (2 Solutions)


3. Delete Gridlines from Graph with Chart Element

Chart elements refer to the many components that make up a chart. To use the char element to remove the gridlines from the excel graph, we need to look at the steps below.

STEPS:

  • To begin, click on the graph and go to the Chart Design from the ribbon.
  • Then, click on the Add Chart Element drop-down menu, under the Chart Layouts category.
  • Further, click on the Gridlines and select Primary Major Horizontal or Primary Major Vertical which gridline you want to remove.

  • Instead of doing this, you can click on the Plus (+) sign, which is the Chat Elements.
  • Then, uncheck the box which is for the Gridlines or uncheck Primary Major Horizontal or Primary Major Vertical which gridline you want to clever from your excel graph.

Delete Gridlines from Excel Graph with Chart Element

  • And, that’s all! The gridlines are removed from your graph.

Delete Gridlines from Excel Graph with Chart Element

Read More: How to Remove Gridlines in Excel for Specific Cells (2 Quick Methods)


4. Format Gridlines Feature to Remove Gridlines from Excel Graph

We can format our excel graph gridlines to remove them. Let’s see the steps to remove gridlines from the excel graph using the format gridlines.

STEPS:

  • Firstly, click on any gridline then right-click.
  • Secondly, go to the Format Gridlines option.

Format Gridlines Feature to Remove Gridlines from Excel Graph

  • Thirdly, select No line to remove all gridlines from the graph.

Format Gridlines Feature to Remove Gridlines from Excel Graph

  • Finally, following the steps will remove all the gridlines from your excel graph.

Read More: Why Do Gridlines Disappear in Excel? (5 Reasons with Solutions)


5. Excel VBA to Remove Gridlines from Excel Graph

With Excel VBA, users can easily use the code which acts as excel menus from the ribbon. To use the VBA code to remove gridlines from excel graphs, let’s follow the procedure.

STEPS:

  • Firstly, go to the Developer tab from the ribbon.
  • Secondly, from the Code category, click on Visual Basic to open the Visual Basic Editor. Or press Alt + F11 to open the Visual Basic Editor.

  • Instead of doing this, you can just right-click on your worksheet and go to View Code. This will also take you to Visual Basic Editor.

  • This will appear in the Visual Basic Editor where we write our codes to create a table from range.
  • Thirdly, click on Module from the Insert drop-down menu bar.

  • This will create a Module in your workbook.
  • And, copy and paste the VBA code shown below.

VBA Code:

Sub Remove_Gridlines()
Dim a As Axes
Dim wsht As Worksheet
Dim ChtObj As ChartObject
For Each wsht In Worksheets
    wsht.Activate
        For Each ChtObj In wsht.ChartObjects
            With ChtObj.Chart
                For Each a In ChtObj.Chart
                    .Axes.HasMajorGridlines = False
                    .Axes.HasMinorGridlines = False
                Next a
            End With
        Next ChtObj
Next wsht
End Sub
  • After that, run the code by clicking on the RubSub button or pressing the keyboard shortcut F5.

  • And, this will remove all the gridlines in the excel graph from the active worksheets.

Conclusion

The above methods will assist you to Remove Gridlines in Excel Graph. Hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section. Or you can have a glance at our other articles in the ExcelDemy.com blog!


Related Articles

Sabrina Ayon

Sabrina Ayon

Hi there! This is Sabrina Ayon. I'm really excited to welcome you to my profile. Currently, I'm working in SOFTEKO as a Excel and VBA Content Developer. I'm a student of United International University and my program is Computer Science and Engineering. I love working with computers and solving problems. I’ve always been interested in research and development. So, here I will be posting articles related to Microsoft Excel. Hoped this may help you. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo