2 Approaches to Add Primary Minor Vertical Gridlines in Excel

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.

Overview Image


📁 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.

Dataset For Adding 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.

Selecting 2D Column Chart

  • We can see Excel Chart has been generated based on the dataset.

Added Chart in Excel


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.

Dataset for Adding Primary Minor Vertical Gridlines in Excel

approach

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.

Selecting Primary Minor Vertical

  • Notice that the primary minor vertical gridlines have been added to the Chart.

Added Primary Minor Vertical Gridlines

📕 Read More: 5 Ways to Add Gridlines After Highlighting in Excel

approach

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.

Selecting Add Chart Element

  • From Add Chart Elements, select Gridlines.
  • Lastly, choose Primary Minor Vertical.

From Gridlines Selecting Primary Minor Vertical

  • We see the Primary Minor Vertical Gridlines added to the chart.

Primary Vertical Gridlines Added


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.

Selecting Primary Major Vertical Gridlines

  • After checking the Primary Major Vertical, we will see primary major vertical gridlines have been added to the chart.

Primary Major Vertical Gridlines Added

📕 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.

Selecting Primary Major Horizontal Gridlines

  • Then, we will see the Primary Major Horizontal gridlines have been added to the chart.

Primary Major Vertical Gridlines Added


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.

Deselect Primary Minor Vertical Gridlines

  • Now, we can see that there are no Primary Minor Vertical gridlines present in the chart.

Primary Minor Vertical Gridlines Removed

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.

(Visited 36 times, 1 visits today)
Sakibul Hasan Nahid

Sakibul Hasan Nahid

Hello I am Sakibul Hasan Nahid. I have completed my BSc. in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. I take a great interest in learning about new technologies and sharing my ideas and thoughts on them with others. Please do reach out to me if you have any queries or recommendations.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo