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 Excel chart effectively with appropriate illustrations.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
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
- As a result, you will be able to create a 3-D column chart which has been given in the below screenshot.
2 Suitable Ways to Adjust Gridlines in Excel Chart
Let’s say, we have a dataset that contains information about several Sales representatives of XYZ group. The Name 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 our today’s task.
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, firstly, check the Gridlines.
- After that, check the Primary Major Horizontal and Primary Major Vertical.
- Hence, you will be able to adjust the Horizontal and Vertical gridlines of the Excel chart like the below screenshot.
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.
- As a result, you will be able to adjust the gridlines of the chart using the Custom Format command.
Read More: How to Change Gridlines in Excel (4 Suitable Ways)
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.
- 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.
Read More: How to Change Gridlines to Dash in Excel (with Easy Steps)
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.
- 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.
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.
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.
