How to Add Grid Lines in Excel Chart

A well-designed Excel chart turns raw numbers into a clear, compelling story. But if your audience has to squint and guess at the values, your story gets lost in translation. Adding gridlines is one of the simplest and most effective ways to make your charts instantly more readable and professional. This guide will walk you through exactly how to add, customize, and effectively use gridlines in your Excel charts.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

We’ll cover everything from the basic one-click method to fine-tuning the color, style, and thickness of your lines, giving you full control over how your data is presented.

What Are Chart Gridlines Anyway?

Gridlines are the faint horizontal and vertical lines that stretch across the plot area of a chart, originating from the axes. Their purpose is purely functional: they provide a visual reference, making it easier for a viewer to trace a data point (like the top of a bar or a point on a line) back to its corresponding value on the vertical or horizontal axis.

Excel gives you control over a few different types of gridlines, and understanding them is the first step to using them effectively.

Major vs. Minor Gridlines

Excel categorizes gridlines into two main types: major and minor.

• Major Gridlines: These are the most common type. They extend from the major tick marks on an axis - the primary, labeled interval markers. For instance, if your vertical axis is labeled 0, 10, 20, 30, and so on, your major gridlines will align perfectly with each of those numbers.
• Minor Gridlines: These provide more granular detail. Minor gridlines appear between the major ones, corresponding to the smaller, unlabeled interval markers on an axis. They are useful for charts where precision matters and you need to estimate values between the major intervals.

You can add them horizontally (extending from the vertical Y-axis) and vertically (extending from the horizontal X-axis), giving you four primary options to start:

• Primary Major Horizontal
• Primary Major Vertical
• Primary Minor Horizontal
• Primary Minor Vertical

For most standard charts like bar graphs and simple line charts, major horizontal gridlines are often all you need to dramatically improve readability.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

How to Add Major Gridlines in Excel: The Quickest Method

Excel makes adding standard gridlines incredibly simple. The fastest way is by using the "Chart Elements" shortcut, which appears right next to your selected chart.

Let's use a sample chart showing monthly sales.

Step 1: Select Your Chart First, click anywhere on your chart. You'll know it's selected when you see a border appear around it, along with a few icons to the top-right.

Step 2: Click the "Chart Elements" Icon Click the green "+" icon (Chart Elements) located in the upper-right corner of the chart. A menu will pop up showing various components you can add or remove, such as Axes, Chart Title, and Data Labels.

Step 3: Add Your Gridlines In the Chart Elements menu, you'll see an option for "Gridlines." Hover your mouse over it (don't click yet!), and you'll see a live preview of how default gridlines will look on your chart.

• To add the default gridlines (usually Primary Major Horizontal), simply check the box next to "Gridlines."
• To choose specific gridline types, click the small black arrow to the right of "Gridlines." This will open a sub-menu where you can independently select Primary Major Horizontal, Primary Major Vertical, Primary Minor Horizontal, and Primary Minor Vertical.

Check the boxes for the gridlines you want to display on your chart. In most cases, starting with Primary Major Horizontal is the best choice for bar and column charts, as it helps connect the top of each bar to its value on the Y-axis.

A Second Way: Using the Excel Ribbon

If you prefer using the ribbon menu at the top of Excel, there’s an alternative way to add gridlines that offers the same options.

Step 1: Select Your Chart Once again, click on your chart. This will reveal the contextual "Chart Design" and "Format" tabs in the main Excel ribbon.

Step 2: Navigate to the Chart Design Tab Click on the "Chart Design" tab.

Step 3: Add a Chart Element On the far left of the Chart Design ribbon, click on the "Add Chart Element" button. A dropdown menu will appear.

Step 4: Choose Your Gridlines Hover over "Gridlines" in the dropdown menu. Another sub-menu will fly out, listing all the gridline options: Primary Major Horizontal, Primary Major Vertical, etc. Simply click on the one you want to add. You can repeat this process to add multiple types of gridlines.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Adding Minor Gridlines for More Precision

Sometimes, major gridlines aren't enough, especially when you need to closely analyze the data. For scientific data, financial charts, or scatter plots where exact values are important, minor gridlines can be a great help.

You can add them using the same methods described above.

1. Click your chart.
2. Click the Chart Elements (+) icon.
3. Click the arrow next to Gridlines.
4. Check the box for Primary Minor Horizontal and/or Primary Minor Vertical.

A word of caution: Be careful not to clutter your chart. Adding both major and minor gridlines in both directions can quickly create a "cage" effect that makes the data itself harder to see. As a rule of thumb, only add minor gridlines if the added precision is truly necessary for interpreting the chart.

How to Customize and Format Your Gridlines

Excel's default gridlines are functional, but they may not perfectly match your presentation's design or branding. Customizing their appearance - changing the color, thickness, or style - is an easy way to give your chart a polished, professional look.

To access the formatting options, you first need to open the "Format Gridlines" pane.

How to Open the Format Gridlines Pane:

• The Easy Way: Right-click directly on one of the gridlines you want to format in your chart. A context menu will appear. Select "Format Gridlines..." at the bottom.
• The Other Way: Click your chart, press the "+" icon, click the arrow next to "Gridlines," and select "More Options..." at the bottom of the list.

Either method will open up the "Format Major Gridlines" (or Minor, depending on what you selected) pane on the right side of your Excel window. Here, under the "Fill & Line" tab (the paint bucket icon), you have full control.

Changing Gridline Color

The default light grey doesn't always stand out or might clash with your background. To change it:

1. In the Format Gridlines pane, make sure you are under the "Line" section.
2. Select "Solid line."
3. Click the paint bucket icon next to "Color" and choose your desired color from the palette.

Pro Tip: Avoid using pure black or very dark colors for your gridlines. They can compete visually with your data series. Softer shades of grey or a light, muted version of your brand color often work best. The goal is to guide the eye, not distract it.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Adjusting Line Weight and Style

You can also make your gridlines thicker, thinner, or even turn them into dashed or dotted lines.

• Width: This controls the thickness of the line. Increase the "Width" value (e.g., to 1.5 pt) for more prominent lines or decrease it (e.g., to 0.25 pt) to make them more subtle.
• Dash type: This dropdown menu lets you change the line's style. You can select from various dotted, dashed, or combination styles. Dashed lines can be a great way to include minor gridlines without creating too much visual noise.

Adding Transparency

One of the most useful formatting tools is transparency. This lets you keep the gridlines visible but soften their impact significantly.

At the bottom of the "Line" options, you'll find the "Transparency" slider. Dragging it to the right (e.g., setting it to 50%) will make the gridlines fainter. This is a powerful technique for keeping the chart clean and ensuring the data remains the main focus.

How to Quickly Remove Gridlines

Decided your chart looks cleaner without gridlines? Removing them is just as easy as adding them.

1. Select your chart.
2. Click the Chart Elements (+) icon.
3. Uncheck the box next to "Gridlines."

This single click will remove all gridlines from your chart. If you only want to remove one type (e.g., vertical gridlines), you can click the arrow next to "Gridlines" and uncheck just that specific box.

Final Thoughts

Mastering chart gridlines in Excel moves you beyond default settings and puts you in full control of how your data is presented. By carefully adding and formatting major and minor gridlines, you guide your audience's eye, improve readability, and create charts that are both beautiful and easy to understand.

While perfecting these small details in Excel is effective, we know that the manual process of creating charts - let alone entire reports and dashboards - takes hours out of your week. With Graphed, we automate the tedious work. Instead of clicking through formatting panes, you can just ask for "a line chart of monthly sales with faint horizontal gridlines," and our AI data analyst builds it for you in seconds from your connected data sources. This frees you up to focus on the insights, not the formatting.