How to Add a Quadratic Trendline to an Excel Chart

Charts & pivot tables · Updated November 21, 2026

To add a quadratic trendline in Excel for Microsoft 365 on Windows, create or select an XY (Scatter) chart, then choose Chart Design > Add Chart Element > Trendline > More Trendline Options. In the Format Trendline pane, select Polynomial and set Order to 2. A quadratic trendline models a curved relationship between numeric x-values and y-values, and Excel can show its equation and R-squared value on the chart.

What You’ll Need

  • A worksheet with at least two columns: numeric x-values and the corresponding y-values. Include column headings so you can identify the series.
  • A useful set of paired observations. Three different x-values are the mathematical minimum for a second-degree curve, but more observations are usually needed to judge whether the curve is meaningful.
  • Excel for Microsoft 365 on Windows. Excel for Mac has similar chart controls, though ribbon labels or pane placement can vary. Excel for the web may not offer every trendline setting; use the desktop app if you cannot select Polynomial or display the equation.

Step-by-Step

  1. Arrange and check the data. Put each x-value beside the y-value measured at that x. For example, column A might contain time values and column B might contain measurements. Keep the headings in the first row and avoid blank rows inside the data. Confirm that the x-values are actual numbers, not text that only looks numeric. Dates are valid x-values when Excel recognizes them as dates; on an XY chart, Excel uses their underlying date serial numbers for spacing.
  2. Select the paired data. Select both columns, including the headings, such as A1:B12. With adjacent columns, Excel generally treats the first column as the x-values and the next as the y-values when creating a scatter chart. If the columns are not adjacent or Excel assigns them incorrectly, create the chart and then use Chart Design > Select Data. Select the series and choose Edit; set Series X values to the x-value cells and Series Y values to the matching y-value cells. Make sure both ranges contain the same number of data cells and exclude the headings from those ranges.
  3. Insert an XY (Scatter) chart. With the data selected, choose Insert > Insert Scatter (X, Y) or Bubble Chart, then choose a scatter option, such as Scatter with only Markers. This chart type places the x-values on a numeric horizontal axis. It is usually a better choice for fitting a polynomial than a Line chart, which can space category labels evenly even when the underlying x-values are unevenly spaced. You can add connecting lines later if they help readers follow the observations.
  4. Select the data series. Click one of the plotted markers once to select the whole series, rather than clicking a single point. If the chart has multiple series, select the series that should receive the curve. A trendline belongs to a particular series; adding one to one series does not fit all the chart’s points together. If selection is difficult, click the chart and use the Chart Format tab’s Current Selection controls to choose the series by name.
  5. Open the trendline settings. Choose Chart Design > Add Chart Element > Trendline > More Trendline Options. You can also right-click the selected series and choose Add Trendline, then open its formatting options. Excel displays the Format Trendline pane. If the Chart Design tab is missing, click the chart first; chart-specific tabs only appear while a chart is selected.
  6. Set the trendline to quadratic. In the Format Trendline pane, choose Polynomial from the trendline options. Set Order to 2. The order is the highest power of x in the fitted polynomial: order 1 is a straight line, while order 2 gives the quadratic form y = ax^2 + bx + c. Do not choose order 3 or a higher value if you specifically need a quadratic trendline. The curve should now appear over the data series.
  7. Show the equation and, if useful, R-squared. In the same pane, select Display Equation on chart to show the fitted coefficients. Select Display R-squared value on chart if you want a summary of how closely the curve matches the plotted observations. These labels are optional; the curve itself does not require either one. Move or resize the equation label so it does not cover important markers. If you need more readable coefficients, right-click the equation label, open Format Trendline Label, and adjust its number format where available.
  8. Review the chart before relying on it. Check that the curve follows the intended series, the horizontal axis contains the right x-values, and the equation has the expected second-degree form. Look for points that sit far from the curve and consider whether they indicate data-entry errors or real variation. Add a clear chart title and axis titles using Chart Design > Add Chart Element if readers need context. Save the workbook after checking that the chart still reflects the intended data range.

Excel fits the coefficients from the selected observations; choosing order 2 does not mean you must calculate those coefficients yourself. The displayed equation is a chart label, not a live worksheet formula for predicting new values. Treat it as a description of the fitted curve, and preserve enough decimal places if you plan to use the coefficients elsewhere.

Common Mistakes

  • Using a Line chart for uneven x-values. A Line chart can treat the horizontal axis as categories, so equal visual spacing may not reflect the actual numeric gaps. Use an XY (Scatter) chart when distances between x-values matter.
  • Fitting the wrong series. A chart with several series can make it easy to select the wrong markers. Confirm the series name and check that the curve passes through the intended group of observations.
  • Leaving the order at 3 or higher. Polynomial is only the trendline type; the Order box determines whether it is quadratic. Explicitly set Order to 2.
  • Using too few or unsuitable data points. Three distinct x-values can define a quadratic exactly, but that does not establish that a curved relationship is reliable. With very few observations, one point can have a large effect on the fit.
  • Reading R-squared as proof of a good model. A high R-squared alone does not show that the quadratic relationship makes sense, will continue outside the observed range, or is appropriate for the data. Inspect the points and consider the context.
  • Copying rounded equation coefficients. The chart label may display fewer digits than Excel used to draw the curve. Increasing the displayed precision can help, but the label is still rounded to its number format.

Tips

Use markers so readers can distinguish actual observations from the fitted curve. A smooth-looking line by itself can obscure how many measurements support it. If the chart has multiple series, give each one a clear name and apply a separate trendline only when fitting each series independently is appropriate.

Keep the curve within the range of observed x-values when your goal is to describe the data. Excel’s trendline options can forecast forward or backward, but extending a quadratic curve is an extrapolation, not a guarantee about future values. Quadratic curves eventually turn or grow rapidly, so even a modest extension can produce implausible results.

If the equation will be used in a report, retain adequate decimal precision and record which observations were included. Consider whether the data are measured consistently and whether an unusual point deserves investigation before fitting. The chart’s equation and R-squared are most useful when read alongside the plotted observations, not as substitutes for them.

Troubleshooting

  • The trendline option is unavailable. Click the chart, then click a plotted data series. If the chart type does not support the option you need, use Chart Design > Change Chart Type and select an XY (Scatter) chart. Try Add Chart Element > Trendline again.
  • The curve is straight or not visibly curved. Reopen Format Trendline and verify that Polynomial is selected and Order is 2. A fitted quadratic can still look nearly straight when its squared-term coefficient is small or the chart’s vertical scale makes the bend hard to see. Do not increase the order simply to make the curve look more dramatic.
  • The line or equation seems to use the wrong data. Select the series, open Chart Design > Select Data, and edit its X and Y ranges. Check that the x- and y-ranges correspond row by row, have equal lengths, and exclude headings. Also confirm that no unintended series was selected before adding the trendline.
  • The plotted x-values appear evenly spaced or out of order. Check that you inserted an XY (Scatter) chart and that the x-values are numeric. If values are stored as text, convert them to numbers or dates and refresh the chart’s data range. Sorting can help make the displayed points easier to follow, but do not change the pairings between each x-value and its y-value.
  • The equation label is missing or hard to read. Select the trendline and check Display Equation on chart in Format Trendline. If it is present but hidden, move the label or enlarge the chart. For a label that is too rounded, change its number format to show additional decimal places.
  • The chart looks different in a browser or on Mac. In Excel for Mac, select the chart and look for the Chart Design trendline controls or open the trendline’s formatting pane; the exact placement can differ from Windows. In Excel for the web, open the workbook in the desktop app if polynomial order or equation display is missing from the available controls.

Frequently Asked Questions

What is a quadratic trendline in Excel?
A quadratic trendline is a second-degree polynomial fit, written as y = ax^2 + bx + c. It can represent a curved relationship between x and y, rather than the constant slope represented by a linear trendline.

How do I make a trendline quadratic?
Select the chart series, open Chart Design > Add Chart Element > Trendline > More Trendline Options, choose Polynomial, and set Order to 2.

Can I add a quadratic trendline to a Line chart?
Some chart types allow trendlines, but an XY (Scatter) chart is the practical choice when x-values are numeric and their spacing matters. Change the chart type to Scatter if Excel does not offer the polynomial settings you need.

How many data points do I need?
Three distinct x-values are the mathematical minimum for determining a quadratic curve. In real analysis, use more observations when possible; the minimum can produce a curve that fits those points exactly without showing whether the pattern is dependable.

Can I use the displayed equation to predict values?
You can use the coefficients as an approximate model, but the chart label may round them. Keep enough precision, use the same x-value units as the chart, and be cautious about predicting outside the observed range.

What does the R-squared value mean?
It summarizes how much of the variation in the plotted y-values is accounted for by the fitted curve under the chart’s calculation. It does not prove that a quadratic model is suitable or that the curve will predict new observations well.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.