How to Add Quadratic Trendline in Excel

When your data doesn't follow a straight line, trying to fit a linear trendline to it is like trying to fit a square peg in a round hole - it just doesn't work. For data that rises and then falls, or dips before it climbs, you need a trendline that can bend. This article will show you exactly how to add and interpret a quadratic trendline in Microsoft Excel to better understand these patterns.

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

What is a Quadratic Trendline?

You can think of a linear trendline as a straight ruler you lay over your data points. It’s perfect when your data consistently moves in one direction - up or down. A quadratic trendline, on the other hand, is like a flexible ruler you can bend once. It creates a U-shaped or an inverted U-shaped curve, known as a parabola.

This single curve makes it the perfect tool for modeling data that has one major peak or valley. A linear model would completely miss this kind of pattern, but a quadratic trendline can capture it beautifully.

When to Use a Quadratic Trendline

So, when does data actually behave this way? It’s more common than you might think. A quadratic model is your go-to choice when your data shows a pattern of acceleration followed by deceleration (or the other way around).

• Product Life Cycles: Sales for a new product often start slow, accelerate as it gains popularity, and then level off and decline as the market becomes saturated. The overall shape of this cycle is often an inverted 'U.'
• Object Trajectory: Think about a ball thrown into the air. Its height increases to a maximum point and then decreases back to the ground, forming a perfect parabolic arc.
• Revenue vs. Price: When you increase the price of a product, you might initially see revenue go up. But at a certain point, a higher price will drive customers away, and revenue will start to fall. Plotting revenue against price often produces a curve a quadratic trendline can model.
• Diminishing Returns: Consider ad spend versus conversions. In the beginning, every extra dollar spent on ads might bring in lots of new customers. But after a while, you reach a saturation point where spending more yields fewer and fewer additional conversions. This pattern of gain and slowdown can be modeled with a quadratic curve.

The key takeaway is this: if your chart visually looks like it has a single hill or a single valley, a quadratic trendline is probably the right analytical tool for the job.

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

Prepare Your Data for Analysis

Before you can add a trendline, your data needs to be structured properly within Excel. Your trendline needs to understand the relationship between two variables: an independent variable (the one you control or that changes predictably, like time) and a dependent variable (the one you measure, which "depends on" the first).

Make sure your data is organized into two columns:

• Column 1 (Independent Variable - X-axis): This is your input, cause, or time series. For example: Days, Ad Spend, Price Point.
• Column 2 (Dependent Variable - Y-axis): This is your output, effect, or metric. For example: Daily Sales, Conversions, Total Revenue.

Let's use a practical example. Imagine we're tracking the number of free trial sign-ups in the days following a major marketing campaign launch. We might expect an initial surge followed by a gradual drop-off.

Here's how that data might look in Excel:

Example Data:

With this clean, two-column setup, we're ready to visualize the data and add our trendline.

How to Add a Quadratic Trendline in Excel: A Step-by-Step Guide

Adding a quadratic trendline involves two main phases: first, creating a visual chart of your data, and second, adding and configuring the trendline itself.

Step 1: Create a Scatter Plot Chart

Before adding a trendline, you need a visual representation of your data. A scatter plot is the ideal chart type for this.

1. Click and drag to select all the data you want to chart, including the column headers (e.g., "Day" and "Sign-ups").
2. Go to the Insert tab on Excel's top ribbon.
3. In the Charts group, click the icon that looks like a set of dots. This is the Insert Scatter (X, Y) or Bubble Chart option.
4. From the dropdown menu, select the first option, Scatter.

Excel will instantly generate a scatter plot showing your data points. For our example, you'll see the points forming a distinct curve - rising for the first few days and then falling.

Step 2: Add the Trendline to Your Chart

Now that you have your chart, you can add the trendline.

1. Click anywhere on the chart to select it. This will make the Chart Design tab appear at the top.
2. In the Chart Design tab, on the far left, click on Add Chart Element.
3. From the dropdown menu, hover over Trendline, and then select More Trendline Options.... This will open the Format Trendline pane on the right side of your screen.

Pro Tip: As a shortcut, you can simply right-click directly on one of the data points in your chart and choose "Add Trendline..." from the context menu.

Step 3: Select the Correct Trendline Option

The Format Trendline pane gives you several types of trendlines. A quadratic trendline is a specific type of polynomial trendline.

1. In the Format Trendline pane, under Trendline Options, select Polynomial.
2. As soon as you select Polynomial, a new field called Order will appear right below it.
3. Crucially, ensure the Order is set to 2. A polynomial of order 2 is, by definition, a quadratic equation (in the form of y = ax² + bx + c). This is what creates the single U-shaped curve we need.

You will immediately see a smooth, curved line appear on your chart that nicely follows the arc of your data points.

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

Step 4: Display the Equation and R-squared Value

The visual line is helpful, but the real power comes from understanding the math behind it. Excel can display this directly on your chart.

1. While still in the Format Trendline pane, scroll down to the bottom.
2. Check the box next to Display Equation on chart.
3. Check the box next to Display R-squared value on chart.

A small text box will appear on your chart with something like:

y = -7.9762x² + 70.357x + 91.5 R² = 0.9855

• The Equation: This is the formula that defines your beautiful curve. We'll use this later for forecasting.
• The R-squared (R²) Value: This number tells you how well the trendline fits your data. It ranges from 0 to 1. An R² value closer to 1 indicates a better fit. Our value of 0.9855 is very high, meaning our quadratic trendline is an excellent model for this data set.

Using the Trendline Equation for Forecasting

Now that you have the formula, you can predict future values. Let's say we want to forecast how many sign-ups we might expect on Day 9 or Day 10, times that are outside our original data.

Our equation is: y = -7.9762x² + 70.357x + 91.5

Here, 'y' represents the number of sign-ups and 'x' represents the day. To forecast for Day 10, we just need to plug 10 into the equation for every 'x'.

You can do this directly in an Excel cell. Assuming Day 10 is what you want to forecast for:

1. Pick an empty cell.
2. Type in the formula, replacing x with the day you want to forecast. For Day 10, the formula would be: = (-7.9762 * (10^2)) + (70.357 * 10) + 91.5
3. Press Enter. Excel calculates the result, which in this case is approximately -2.88.

Our model predicts we'll get a negative number of sign-ups, which is obviously impossible. This leads to a crucial warning...

Common Pitfalls and Best Practices

Adding a trendline is easy, but interpreting it correctly requires care. Keep these points in mind to avoid common mistakes.

1. The Danger of Extrapolation

As our forecasting example showed, predicting values far beyond your original data range (called extrapolation) can be unreliable. Our model fit the data from Days 1-8 perfectly, but the parabolic curve will continue steeply downwards into negative territory forever. Use trendlines for forecasting values that are a reasonable distance from your original data. A forecast for "Day 9" might be useful, but a forecast for "Day 50" would be pure guesswork.

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

2. Don't Overcomplicate It with a Higher Order

It can be tempting to increase the Polynomial order to 3, 4, or 5 to get an R-squared value even closer to 1. This is called "overfitting." While the line might wiggle perfectly through all your existing data points, it will likely be a terrible predictor of future trends because it's modeling the random noise, not the underlying pattern.

Rule of thumb: Unless you have a strong theoretical reason, stick to Order 2 for data with one curve.

3. Check for Outliers

A single, highly unusual data point (an outlier) can dramatically pull the trendline in its direction and skew your entire analysis. Before finalizing your chart, scan your data points to see if one value looks completely out of place. If it is, investigate whether it was a data entry error or a truly anomalous event.

Final Thoughts

Mastering the quadratic trendline unlocks a new level of analysis in Excel, allowing you to accurately model and understand data that doesn’t follow a simple straight path. By creating a scatter plot, adding a polynomial trendline of order 2, and displaying the R-squared value, you can confidently analyze patterns that have a single peak or valley.

While Excel is fantastic for hands-on analysis, the process of creating charts, adjusting settings, and digging for insights across different platforms can be time-consuming. We built Graphed to solve this by connecting directly to your live data sources and letting you build dashboards using simple "show me" and "compare" prompts. You can describe what you need in plain English - like "Compare sign-ups vs. ad spend for the last 30 days" - and get a real-time, shareable dashboard in seconds, not hours.