How to Add Vertical Gridlines to Excel Chart (2 Easy Methods)

Gridlines are horizontal and vertical lines that run through your chart layout to represent axis divisions. It is beneficial to add horizontal or vertical gridlines to a chart to make the data simpler to read. In this tutorial, we will show you how to add vertical gridlines to an Excel chart.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


2 Handy Approaches to Add Vertical Gridlines to Excel Chart

An example data set reflecting the Sales value with the Month for various Sales Persons are shown in the figure below. We’ll make a chart that shows Sales vs. Months and add vertical gridlines to it. To add the vertical gridlines, we will use two methods: the Chart Element Button and the Chart Tools Menu.

Sample Data

1. Apply the Chart Elements Button to Add Vertical Gridlines to Excel Chart

First of all, we need to make a chart with the Months and Sales Value. To do so, follow the simple steps below.

Step 1: Insert a Chart

  • Firstly, click on the Insert.
  • From the Charts Ribbon, select any chart option you prefer.

Handy Approaches to Add Vertical Gridlines to Excel Chart

Step 2: Add a Chart Layout

  • Select a Chart Layout.

Handy Approaches to Add Vertical Gridlines to Excel Chart

Step 3: Use the Data Ribbon

  • Click on the Select Data option to add data to the Chart.

Handy Approaches to Add Vertical Gridlines to Excel Chart

Step 4: Select the Data for the Chart

  • Select the data in the image to input the chart data in the Chart data range
  • Then, click on OK.

Handy Approaches to Add Vertical Gridlines to Excel Chart

  • Therefore, your chart will appear as the image shown below.

Handy Approaches to Add Vertical Gridlines to Excel Chart

1.1 Add Primary Major Vertical Gridlines

Steps:

  • Firstly, click on the right side (+) icon to show the Chart Elements.
  • Select the Gridlines.

Handy Approaches to Add Vertical Gridlines to Excel Chart

Handy Approaches to Add Vertical Gridlines to Excel Chart

  • Therefore, your Primary Major Vertical lines will show in the image shown below.

Handy Approaches to Add Vertical Gridlines to Excel Chart

1.2 Add Primary Minor Vertical Gridlines

Steps:

  • From the Gridlines option, select the Primary Minor Vertical.

Handy Approaches to Add Vertical Gridlines to Excel Chart

  • As a result, the Primary Minor Vertical lines will show up like this.

Handy Approaches to Add Vertical Gridlines to Excel Chart

1.3 Format the Gridlines

Steps:

  • To Format or add more options, click on More Options.

Handy Approaches to Add Vertical Gridlines to Excel Chart

  • To add a solid vertical line, select the Solid Line.

Handy Approaches to Add Vertical Gridlines to Excel Chart

  • The solid vertical lines are added in this manner, as demonstrated in the figure below.

Handy Approaches to Add Vertical Gridlines to Excel Chart

  • To add gradient lines, select the Gradient line.

Handy Approaches to Add Vertical Gridlines to Excel Chart

  • Adding a Gradient line will result in the chart displayed in the image below.

Sample Data

Read More: How to Show Gridlines after Using Fill Color in Excel (4 Methods)


2. Use the Chart Tools Menu to Add Vertical Gridlines to Excel Chart

Besides the Chart Elements option, we can use the Chart Tools menu to add vertical gridlines. Follow the outlined instructions below to apply the Chart Tools menu.

Step 1: Add Primary Major Vertical Gridlines

  • Firstly, click on the Chart Design.
  • Select the Add Chart Element.
  • Then, select Gridlines.
  • Finally, choose the Primary Major Vertical.

Sample Data

  • Therefore, you will get the Primary Major Vertical.

Sample Data

Step 2: Add Primary Minor Vertical Gridlines

  • From the Gridlines option, choose the Primary Minor Vertical.

Sample Data

  • As a result, after adding the Minor Vertical lines, your chart will display as the image shown below.

Sample Data

Read More: How to Make Gridlines Darker in Excel (2 Easy Ways)


Conclusion

To conclude, I hope this article has given you some useful information about how to add vertical gridlines to an Excel chart. All of these procedures should be learned and applied to your dataset. Take a look at the practice workbook and put these skills to the test. We’re motivated to keep making tutorials like this because of your valuable support.

If you have any questions – Feel free to ask us. Also, feel free to leave comments in the section below.

We, The Exceldemy Team, are always responsive to your queries.

Stay with us & keep learning.


Related Articles

Bhubon Costa

Bhubon Costa

Myself, Bhubon Costa, an engineer, is currently employed with Exceldemy as an Excel & VBA Content Developer. I appreciate solving analytical difficulties, finding practical answers, and, for the most part, I enjoy taking on new tasks. I write articles on Exceldemy about various ways to get out of Microsoft Excel's stuck conditions. My passion is to leave my mark on the world through my work and to have an impact on the community who benefit from it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo