How to Add Y-Intercept on Excel Graph

Showing your graph’s y-intercept in Excel isn’t just for math class — it’s a powerful way to understand the baseline value of your data. This article will walk you through several easy ways to find, display, and even set the y-intercept, giving you a clearer picture of what your numbers are really telling you.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

First, A Quick Refresher: What Is the Y-Intercept?

Before jumping into the "how," let's quickly clarify what we're talking about. The y-intercept is the point where a line on your graph crosses the vertical Y-axis. In simple terms, it's the value of Y when X is equal to zero.

Why does this matter? Imagine you’re plotting advertising spend (X-axis) against website traffic (Y-axis). Your y-intercept would represent the amount of website traffic you’d get with $0 in ad spend. This is your baseline organic traffic, a number that's incredibly useful for measuring the true impact of your marketing efforts. Finding it helps you separate the results you pay for from the results you earn organically.

The Easiest Method: Displaying the Y-Intercept on a Trendline

The most common and visual way to show the y-intercept is to add a trendline to your scatter plot or line chart and display its formula. Excel makes this remarkably simple.

Let's say we have monthly data for marketing spend and the number of leads generated. We want to visualize the relationship and find our baseline leads if our spend were zero.

Step 1: Create Your Scatter Plot

If you don't already have a chart, creating one takes just a few clicks.

• Select your two columns of data. Make sure your independent variable (like "Spend") is in the left column and your dependent variable (like "Leads") is in the right.
• Go to the Insert tab on the Ribbon.
• In the Charts group, click the icon that looks like a set of dots (Insert Scatter (X, Y) or Bubble Chart).
• Choose the first option, Scatter.

You'll now have a basic scatter plot of your data points.

Step 2: Add and Format the Trendline

Now, let's add the trendline that will reveal our y-intercept.

• Right-click on any of the data points in your chart. A context menu will appear.
• Select Add Trendline... from the menu.
• A "Format Trendline" pane will open on the right side of your screen. By default, Excel usually selects a Linear trendline, which is what we need for a simple y = mx + b analysis.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Display the Equation on the Chart

With the "Format Trendline" pane still open, you're just one checkbox away from finding the intercept.

• Scroll down to the bottom of the Trendline Options.
• Check the box labeled Display Equation on chart.
• (Optional but recommended) While you're here, also check Display R-squared value on chart. R-squared tells you how well your trendline fits your data, which is useful for context.

A small text box will immediately appear on your chart showing the formula for your trendline, typically in the format y = mx + b.

For example, you might see something like: y = 2.54x + 48.7

In this famous formula:

• y is your dependent variable (Leads).
• m (2.54) is the slope of the line, showing how many additional leads you get for every dollar spent.
• x is your independent variable (Spend).
• And the magic number, b (48.7), is your y-intercept!

This means if your marketing spend were zero (x=0), your model predicts you would still generate about 49 leads. This is your baseline, instantly visible right on the chart. You can click and drag the equation box to place it wherever you'd like on your chart for better visibility.

How to Force the Trendline to Intercept at Zero

Sometimes your data model requires the trendline to start at the origin (0,0). For instance, if you're plotting units sold (X-axis) against total revenue (Y-axis), it’s logical that zero units sold should result in zero revenue. In these cases, you can force Excel's trendline to use zero as the intercept.

• Follow the steps above to add a trendline to your chart.
• In the "Format Trendline" pane, look for the option labeled Set Intercept. It’s usually located near the middle of the options.
• Check the box and ensure the value in the input field next to it is 0.0.

Your trendline will immediately adjust, pivoting so that it passes directly through the (0,0) point on your graph. Keep in mind, this can sometimes lower your R-squared value because you're forcing the line to fit a specific condition rather than finding the mathematically ideal fit for the data points you have.

Use this with caution. Only force an intercept if your real-world scenario logically demands it. Many datasets, like our marketing spend example, have a natural, non-zero baseline. Forcing that to zero would misrepresent the data and lead to incorrect assumptions.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Calculating the Y-Intercept Without a Graph: The INTERCEPT Function

What if you don't need a chart at all? Maybe you just need to calculate the y-intercept value to use in a summary table or another formula. Excel has a dedicated function for this called INTERCEPT.

The syntax for the function is very straightforward:

=INTERCEPT(known_y's, known_x's)

• known_y's: This is the range of cells containing your dependent variable (your Y-axis data).
• known_x's: This is the range of cells containing your independent variable (your X-axis data).

How to Use It

Let's stick with our example where monthly leads are in cells B2 through B13 and the corresponding ad spend is in cells A2 through A13.

• Click on any empty cell where you want the y-intercept value to appear.
• Type the following formula:

=INTERCEPT(B2:B13, A2:A13)

• Press Enter.

The cell will now display the y-intercept value calculated from your data. This is the exact same number you would see in the trendline equation on the chart, but now you have it as a distinct value you can reference elsewhere in your spreadsheet.

Another Formula Method: Using FORECAST.LINEAR

Believe it or not, there's another great function that can pull double duty to find the y-intercept: FORECAST.LINEAR. This function is typically used to predict a future Y value based on a given X value. But remember our definition: the y-intercept is simply the value of Y when X is 0.

So, we can use FORECAST.LINEAR and tell it to find the forecast for an X value of 0! The syntax is:

=FORECAST.LINEAR(x, known_y's, known_x's)

• x: The x-value for which you want to predict a y-value. For finding the intercept, this will always be 0.
• known_y's: The range for your dependent variable.
• known_x's: The range for your independent variable.

How to Use It

Using the same data ranges as before (A2:A13 for spend and B2:B13 for leads), the formula would be:

=FORECAST.LINEAR(0, B2:B13, A2:A13)

When you press Enter, Excel will return the y-intercept. This result should be identical to the one you got using the INTERCEPT function, making it a great way to double-check your work.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Pro Tip: Add a Dynamic Intercept to Your Chart Title

Now let's combine these skills to create a smarter, more professional chart. Instead of just having a static title like "Marketing Performance," you can make it dynamically display the calculated y-intercept (your performance baseline).

• First, calculate an intercept value in a spare cell. Let's say you use the formula =INTERCEPT(B2:B13, A2:A13) in cell E1. This cell now holds your baseline leads number.
• Click on your chart title to select it.
• Don't click inside the text box itself. Instead, go directly to Excel's Formula Bar (the long bar above the column headers).
• Type an equals sign (=) in the Formula Bar.
• Now, click on the cell containing your y-intercept calculation (cell E1 in our example).
• Press Enter.

Your chart title now displays the number from cell E1. If your data changes, the formula in E1 will recalculate, and your chart title will update automatically!

You can even make it more descriptive by combining it with text using a formula in another cell. In cell E2, for instance, you could type:

="Leads vs. Spend (Baseline: " & TEXT(E1,"0") & " Leads)"

Then, simply link your chart title to cell E2 instead of E1. Now your chart title could read "Leads vs. Spend (Baseline: 49 Leads)," which is much more insightful for anyone reading the report.

Final Thoughts

Mastering the y-intercept in Excel elevates your charts from simple pictures of data to powerful analytical tools. Whether you're displaying it on a trendline, calculating it directly with the INTERCEPT function, or setting up dynamic titles, understanding your baseline value is a fundamental step toward making smarter, data-driven decisions.

While Excel is powerful, spending all your time toggling through format panes and crafting formulas can be a drag, shifting focus from insight to implementation. We built Graphed because we believe getting answers from your data shouldn't be so manual. Instead of digging through menus, you can simply connect your data sources and ask questions like, "Show me how our marketing spend correlates with monthly leads" or "What's our baseline website traffic?" and get a clean, interactive visualization in seconds.