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.
Download Practice Workbook
Download this workbook and practice while going through the article.
2 Simple Methods on How to Add Primary Minor Vertical Gridlines in Excel
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.
- 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.
- 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.
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.
- Create a column chart following method-1.
- Then, click on the Chart Elements icon.
- After that, select Gridlines.
- Then, check the box for Primary Minor Vertical.
- Excel will add vertical gridlines.
Things to Remember
- You will not get the Chart Elements in the earlier versions of Excel.
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. Please visit Exceldemy for more useful articles like this.