How to Add Primary Minor Vertical Gridlines in Excel (2 Ways)

Get FREE Advanced Excel Exercises with Solutions!

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes we need to illustrate a dataset with the help of charts. Excel has a lot of them. Moreover, you can format these charts too. In this article, I will show you 2 methods on how to add primary minor vertical gridlines in Excel.


How to Add Primary Minor Vertical Gridlines in Excel: 2 Simple Methods

This is the dataset for today’s article. We have some products and their respective Sales Amount. I will illustrate these values in a column chart and then add primary minor vertical gridlines to the chart.


1. Using Chart Tools to Add Primary Minor Vertical Gridlines in Excel

First of all, I will show how to use the chart tools. Chart tools are useful features that help modify the chart.

Steps:

  • First of all, select B4:C10.
  • Then, go to the Insert tab.
  • After that, select the drop-down box for column charts (see image).
  • Finally, choose a column chart.

  • Excel will create a column chart.

how to add primary minor vertical gridlines in excel

  • Now, go to the Chart Design.
  • After that, select Add Chart Elements.
  • Then, select Gridlines.
  • Finally, select Primary Minor Vertical.

  • Excel will create primary minor vertical gridlines.

how to add primary minor vertical gridlines in excel

Read More: How to Add Gridlines to a Graph in Excel


2. Applying Chart Elements to Add Primary Minor Vertical Gridlines

Now, I will discuss another method to add primary minor vertical gridlines. I will use chart elements this time.

Steps:

  • Create a column chart following method 1.

  • Then, click on the Chart Elements icon.

how to add primary minor vertical gridlines in excel

  • After that, select Gridlines.
  • Then, check the box for Primary Minor Vertical.

  • Excel will add vertical gridlines.

how to add primary minor vertical gridlines in excel

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


Things to Remember

  • You will not get the Chart Elements in the earlier versions of Excel.

Download Practice Workbook

Download this workbook and practice while going through the article.


Conclusion

In this article, I have explained 2 methods to add primary minor vertical gridlines. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below.


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.
Akib Bin Rashid
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo