How to Make Trendline Start from 0 in Google Sheets

Seeing your Google Sheets trendline float in space instead of starting neatly at zero can be incredibly frustrating. It can make a perfectly good chart look misleading or unprofessional. This guide will walk you through not only how to fix this visually but also how to create a mathematically accurate trendline that truly originates at (0,0), and most importantly, help you decide when it's the right call for your data.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Your Trendline Doesn’t Magically Start at Zero

Before jumping into the fixes, it's helpful to understand what a trendline actually is. A trendline is a calculated "line of best fit" for your data points. Google Sheets uses a mathematical model called linear regression to draw a line that comes as close as possible to all of your data points at once. Its primary goal is to represent the overall trend, not to necessarily pass through the chart's origin (the 0,0 point).

Think about a chart of your monthly sales. If you made $10,000 in January (Month 1), $10,500 in February (Month 2), and so on, the trendline will start somewhere near the $10,000 mark. It wouldn’t make sense for it to start at $0 because you never actually had a month with zero sales. The line’s starting point on the y-axis (known as the y-intercept) is determined by the data itself.

So, the two main reasons your trendline doesn't start at zero are:

• Axis Scaling: Google Sheets automatically sets the vertical axis minimum value based on your data to make the chart easy to read, which might mean the '0' point isn't even visible.
• Mathematical Accuracy: The calculated line of best fit for your specific data set simply doesn't pass through the (0,0) point.

Let's tackle both of these issues with practical, step-by-step solutions.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

The Easiest Fix: Adjust the Vertical Axis Minimum to 0

Often, the problem isn't the trendline itself, but how the chart is displayed. Your data might be clustered in a range far from zero (like 1000 to 1200), so Google Sheets zooms in on that area, visually cutting off the origin. Forcing the vertical axis to start at 0 is the most common and simplest fix to make your chart look right.

Here’s how to do it:

Step 1: Open the Chart Editor Double-click anywhere on your chart. This will open the Chart editor pane on the right side of your screen.

Step 2: Navigate to Vertical Axis Settings In the Chart editor, make sure you are on the Customize tab. Scroll down and click on the Vertical axis section to expand its options.

Step 3: Set the Minimum Value to 0 You'll see fields for Min and Max values. They are likely blank, meaning Google Sheets is setting them automatically. Click inside the Min text box and type 0. Press Enter.

Instantly, your chart’s vertical axis will re-scale to start at 0. This single change often resolves the visual issue. Your trendline will now be shown in its full context, and while it may not originate precisely at zero, the entire chart will be grounded properly at the zero baseline. This method is all about changing the visual perspective without altering the mathematical integrity of the trendline itself.

When Forcing a Zero Intercept Is Necessary (and How to Do It)

Sometimes, simply changing the axis isn't enough. Your data might logically require that the trendline starts at zero. For example, if you're plotting hours worked vs. earnings, it’s a given that 0 hours of work results in $0 of earnings. In cases like this, you want a trendline that is forced to pass through the (0,0) origin.

This is where Google Sheets has a slight limitation. Unlike Microsoft Excel, Sheets does not have a simple "Set Intercept = 0" checkbox in its trendline options. That means we need to get a little clever and create our own trendline using a helper column and some simple formulas.

Don't worry, it's easier than it sounds. We're going to create a new data series that represents our zero-intercept trendline and then plot it on top of our original data.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

The Manual Trendline Workaround

Let’s use an example. Imagine you have data in columns A and B tracking ad spend (X-axis) vs. conversions (Y-axis). It's reasonable to assume $0 in ad spend will result in 0 conversions from that ad.

Step 1: Calculate the Average Rate (Slope) To create a trendline that starts at zero, we first need to figure out its slope, or its "rate of change." Since we are forcing the origin to (0,0), the slope for any given point (x,y) is simply y divided by x. We can then average this rate across all our data points to find a representative slope.

Find an empty cell on your sheet and enter the following formula. This calculates the average (conversions / ad spend) for all your data points:

=AVERAGE(B2:B10 / A2:A10)

(Be sure to adjust B2:B10 and A2:A10 to match your actual data range. This is an array formula, so if you are on an older version of Sheets and it errors, you may need to wrap it in =ARRAYFORMULA(...).)

Let’s say this formula gives you a result of 0.25. This is the slope of our forced-zero trendline. It means that, on average, you get 0.25 conversions for every $1 of ad spend.

Step 2: Create a Helper Column for the Trendline Data Now, we'll use this slope to create the data points for our new trendline. Go to the column right next to your data (Column C in our example) and give it a header like "Zero-Intercept Trend".

In the first cell of this column (C2), enter a formula that multiplies your calculated slope by the corresponding x-value (from column A):

=$E$1 * A2

Replace $E$1 with the cell where your slope calculation resides. Make sure to make it an absolute reference so it doesn't change when you drag the formula down.

Step 3: Apply the Formula to All Rows Click on the small blue square (the fill handle) in the bottom-right corner of cell C2 and drag it down to the last row of your data. This will create a trendline value for each x-axis point. You now have a third column that represents a perfectly straight line starting at zero.

Step 4: Add the New Series to Your Chart It's time to put your shiny new trendline on the chart.

1. Double-click your chart to open the Chart editor.
2. Go to the Setup tab.
3. Click on Add series and select the data range for your new helper column (e.g., C1:C10).

You'll see your original scatter plot points and a new set of points from your helper column. Now, let’s make it look like a real trendline.

Step 5: Format the New Series as a Trendline

1. In the Chart editor, go to the Customize tab and select your new series (e.g., "Zero-Intercept Trend").
2. Change the color if you wish.
3. Change the Point size to None to hide the individual dots. This is the magic step that makes it look like a line instead of a scatter plot.
4. Optionally, turn on the Trendline checkbox for this series. Since the series is already a perfect line, it will simply lay a clean line overtop. You can then adjust the line thickness and style (like a dashed line) to make it look distinct.

You did it! You now have your original data displayed as points and a separate, manually-created line series that starts at zero and represents the trend through your data.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

The Golden Rule: Should You Force Your Trendline to Start at Zero?

Just because you can force your trendline to start at zero doesn’t always mean you should. Manipulating visualizations to fit a certain narrative can be misleading. Always ask yourself: “Does a zero value on my x-axis logically have to lead to a zero value on my y-axis?”

Situations Where It Makes Sense:

• Direct Proportions: Units sold vs. revenue, miles driven vs. fuel used, time spent on a project vs. work completed. In all these cases, zero of the first thing naturally results in zero of the second.
• Conversion Rates: Ad spend vs. ad-driven signups, ad impressions vs. ad-clicks. If there is no ad, there can be no conversion from it.

Situations Where You Should Avoid It:

• Baseline Values: Charting temperature over the day, stock prices over a week, or website users per month for an established site. The starting point is not zero, there is an existing value before your measurement begins.
• Independent Variables: Analyzing employee test scores vs. years of experience. Someone with "0" years of experience could still score above zero. A line forced through the origin would inaccurately represent their starting competency.

The original, mathematically calculated trendline from Google Sheets tells the honest story of your data. Forcing a zero-intercept can distort that story. Use the visual axis-adjustment trick freely, but only use the manual trendline method when the logic of your data absolutely supports it.

Final Thoughts

Fixing a floating trendline in Google Sheets usually comes down to two paths: a simple visual adjustment of the vertical axis, or a more involved but accurate manual workaround when your data must start at zero. Understanding the difference between what your chart looks like and what the data means is key to creating reports that are both clean and truthful.

Manually calculating slopes and creating helper columns in spreadsheets gets the job done, but it can quickly become tedious, especially when you need to combine data from multiple platforms like Google Analytics, Shopify, or your CRM. At Graphed, we automate all of that away. You can connect all your data sources in just a few clicks and simply ask for a chart in plain English like, "show me a trendline of conversions vs ad spend this quarter." We’ll instantly build a live, interactive dashboard for you, no formulas required.