There are two kinds of gridlines in chart: Horizontal and Vertical gridlines. These gridlines help us to visualize the data more effectively. There are two kinds of vertical gridlines: Primary Major Vertical Gridlines and Primary Minor Vertical Gridlines. We will demonstrate 2 easy ways for adding primary minor vertical gridlines.
Here, we are providing an overview of our article.
📁 Download Excel File
Download the Excel file here.
How to Add Charts in Excel
Before learning how to add primary minor vertical gridlines in Excel, we need to know how to add charts in Excel. A chart is used for the graphical presentation of data in a formal way. To make a dataset easily understandable to the users, we use Chart. We will utilize following dataset to add a chart in Excel.
We will follow the given steps below to add charts in Excel.
⬇️⬇️ STEPS ⬇️⬇️
- Select the dataset.
- Then, go to Insert tab from the Charts group and select Insert Column or Bar Chart.
- After that, select 2D Column.
- We can see Excel Chart has been generated based on the dataset.
Learn to Add Primary Minor Vertical Gridlines in Excel with These 2 Approaches
We know how to generate Excel Chart. This time we will learn how to add primary minor vertical gridlines in Excel. We will apply the previous dataset here.
1. Add Primary Minor Vertical Gridlines from Chart Elements
In this method, we will adopt Chart Elements to add primary minor vertical gridlines using the given steps below.
⬇️⬇️ STEPS ⬇️⬇️
- We can see a bar chart has been created based on the dataset. Click the (+) icon of the chart.
- Then, check the Gridlines and click the arrow. From there select the Primary Minor Vertical.
- Notice that the primary minor vertical gridlines have been added to the Chart.
📕 Read More: 5 Ways to Add Gridlines After Highlighting in Excel
2. Insert Minor Vertical Gridlines from Chart Tools
Now, we will add the primary vertical gridlines using the Chart Tools from the Excel Ribbon following the steps below.
⬇️⬇️ STEPS ⬇️⬇️
- We already created the chart like the previous method. Then, instead of clicking the (+) icon, we will go to Excel Ribbon.
- From Chart Design section, select the Add Chart Element.
- From Add Chart Elements, select Gridlines.
- Lastly, choose Primary Minor Vertical.
- We see the Primary Minor Vertical Gridlines added to the chart.
How to Add Primary Major Vertical Gridlines in Excel
We have already learned how to add primary minor vertical gridlines. Here, we will learn to add primary major vertical gridlines in chart.
⬇️⬇️ STEPS ⬇️⬇️
- Here, we will add the chart following the previous methods.
- Then, click the (+) icon of the chart.
- From there we will select the Gridlines.
- After that, we will select the Primary Major Vertical.
- After checking the Primary Major Vertical, we will see primary major vertical gridlines have been added to the chart.
📕 Read More: 2 Approaches to Add More Gridlines in Excel
How to Add Primary Major Horizontal Gridlines in Excel
Here, we will add primary major horizontal gridlines in Chart by following the steps below.
⬇️⬇️ STEPS ⬇️⬇️
- First, we will add a chart against a dataset.
- Then, we will click the (+) icon.
- After that, we will select the Gridlines.
- From Gridlines, we will choose Primary Major Horizontal.
- Then, we will see the Primary Major Horizontal gridlines have been added to the chart.
How to Remove Gridlines in Excel
If we want to remove only the Primary Minor Vertical Gridlines in Excel, we can do it too. Follow the steps below for this.
⬇️⬇️ STEPS ⬇️⬇️
- First, select the Chart.
- Then, move to the (+) icon of the Chart.
- From Gridlines, uncheck the Primary Minor Vertical.
- Now, we can see that there are no Primary Minor Vertical gridlines present in the chart.
To remove the other gridlines you just need to uncheck the other gridlines options and you will able to remove the other gridlines from the chart.
📝 Takeaways from This Article
📌 In this article, we learned to add Minor Vertical Gridlines in Excel.
📌 Here, we have used the Chart Elements and Chart Tools to add primary minor vertical gridlines in Excel.
Conclusion
Finally, we have come to the conclusion of this article. In this article, we tried to provide every possible way to add primary minor vertical gridlines in Excel. As many methods have been demonstrated here, you may quickly choose which one is suitable for you. For any kind of query, please write in the comments section. Finally, we propose that you visit ExcelDen to discover more about Excel.