How to Adjust Gridlines in Excel Chart (2 Ways)

Get FREE Advanced Excel Exercises with Solutions!

While working with Microsoft Excel, sometimes we need to adjust the gridlines in an Excel chart. Gridlines are very useful for quickly calculating the height or breadth of visual components used in our chart. This is an easy and time-saving task in Excel also. Today, in this article, we’ll learn two quick and suitable ways to adjust gridlines in an Excel chart effectively with appropriate illustrations.


Create an Excel Chart

Firstly, we will create an Excel chart to adjust the gridlines in Excel charts. Using Insert ribbon, we will import a chart from our dataset to adjust the gridlines. This is an easy task. This is a time-saving task also. Let’s follow the instructions below to adjust the gridlines!

Steps:

  • First of all, select the range of data to draw a chart.
  • From our dataset, we select B4 to E15 for the convenience of our work.
  • After selecting the data range, from your Insert ribbon, go to,

Insert → Charts → 3-D Column

Create an Excel Chart

  • As a result, you will be able to create a 3-D column chart which has been given in the below screenshot.


How to Adjust Gridlines in Excel Chart: 2 Suitable Ways

Let’s say, we have a dataset that contains information about several Sales representatives of XYZ group. The Names of the Sales representatives and their sales in several quarters are given in columns B, C, D, E, and F respectively. From our dataset, we will create a chart to adjust gridlines, and we will apply the Chart Element Option and Chart Design command to adjust the gridlines of a chart in Excel. Here’s an overview of the dataset for today’s task.

Use Chart Elements Option to Adjust Gridlines in Excel Chart


1. Use Chart Elements Option to Adjust Gridlines in Excel Chart

In this method, we will use the Chart Elements option to adjust the gridlines of an Excel chart. From our dataset, we can easily do that. Let’s follow the instructions below to adjust the gridlines in an Excel chart!


1.1 Add Horizontal and Vertical Gridlines

In this sub-method, we adjust the Horizontal and Vertical gridlines using the Chart Elements option. Let’s follow the instructions below to learn!

Steps:

  • Our created chart is given below.

  • After creating an Excel chart, press any portion of your chart.
  • As a result, a Chart Elements option will appear in front of you on the right-top.
  • From the Chart Elements option, first, check the Gridlines.
  • After that, check the Primary Major Horizontal and Primary Major Vertical.

Use Chart Elements Option to Adjust Gridlines in Excel Chart

  • Hence, you will be able to adjust the Horizontal and Vertical gridlines of the Excel chart like the below screenshot.

Use Chart Elements Option to Adjust Gridlines in Excel Chart

Read More: How to Add Primary Major Horizontal Gridlines in Excel


1.2 Custom Format Gridlines

In this sub-method, we will use the Custom Format option to adjust the gridlines. Let’s follow the instructions below to learn!

Steps:

  • First of all, press any portion of your chart.
  • From the Chart Elements option, firstly, check the Gridlines.
  • After that, select More Options….

  • As a result, a Format Major Gridlines dialog box will appear in front of you.
  • From the Format Major Gridlines dialog box, firstly, select Fill & Line.
  • Hence, select the Solid line from the Line option.
  • Further, select the Red color from the Color option.

Use Chart Elements Option to Adjust Gridlines in Excel Chart

  • As a result, you will be able to adjust the gridlines of the chart using the Custom Format command.


2. Apply Chart Design Command to Adjust Gridlines in Excel Chart

Now, we will apply the Chart Design command to adjust gridlines. From our dataset, we can easily do that. Let’s follow the instructions below to learn!

Steps:

  • First of all, select the chart.

Apply Chart Design Command to Adjust Gridlines in Excel Chart

  • After that, from the Chart Design ribbon, go to,

Chart Design → Add Chart Element → Gridlines → Primary Major Horizontal

  • As a result, you will be able to adjust the Primary Major Horizontal gridlines which have been given in the below screenshot.

Apply Chart Design Command to Adjust Gridlines in Excel Chart


Remove Gridlines from Excel Chart

In this section, we will learn how to remove the gridlines from an Excel chart. This is an easy and time-saving task. Let’s follow the instructions below to remove the gridlines in an Excel chart!

Steps:

  • First of all, select the chart.

Remove Gridlines from Excel Chart

  • As a result, a Chart Elements option will appear in front of you in the right-top corner.
  • From the Chart Elements option, uncheck the Gridlines option.

  • Hence, you can remove the gridlines from the Excel chart.

Remove Gridlines from Excel Chart

Read More: How to Remove Gridlines in Excel Graph


Things to Remember

➜ While a value can not found in the referenced cell, the #N/A! the error happens in Excel.

➜ #DIV/0! the error happens when a value is divided by zero(0) or the cell reference is blank.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Conclusion

I hope all of the suitable methods mentioned above to adjust gridlines in an Excel chart will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.


Related Articles


<< Go Back To Gridlines in Excel Chart | Excel Chart Elements | Excel Charts | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Abdur Rahim Rasel
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo