How to Make a Quadratic Trendline in an Excel Chart

Charts & pivot tables · Updated November 21, 2026

To make a quadratic trendline in Excel, create an XY (Scatter) chart from paired numeric data, select the chart, then choose Chart Design > Add Chart Element > Trendline > More Trendline Options. In the Format Trendline pane, select Polynomial and set Order to 2. This fits a curved line in the form y = ax² + bx + c to your data. Before you begin, make sure your x-values and y-values are in separate columns and each row contains a matching pair.

What You’ll Need

  • Excel for Microsoft 365 on Windows. The steps are similar in current desktop versions of Excel for Mac.
  • A small table with one numeric x-value and one numeric y-value for each observation. Include column headings, but not totals or summary rows in the chart data.
  • Enough observations to make a curve meaningful. Three different x-values are the mathematical minimum for calculating a quadratic curve, but more points are usually needed to judge whether the curve describes the pattern well.

A quadratic trendline is a second-order polynomial. It can show a single bend, such as a rise that slows and then falls, or a dip followed by a rise. It does not prove that the pattern will continue, and a curved fit is not automatically better than a straight line. The shape should make sense for the data and the question you are trying to answer.

Step-by-Step

  1. Arrange the data as paired values. Put the independent or input values in one column and the measured values in the next. For example, column A could contain elapsed time in months and column B could contain a measurement taken at each month. Put a clear heading in the first row, such as Month and Measurement. Each row below the headings must refer to the same observation in both columns. Do not put a separate total in the selected range.
  2. Check that the x-values are numeric. Excel needs numeric horizontal values to fit a curve correctly. Numbers stored as text, category names, and inconsistently formatted dates can produce an unexpected chart. Dates can be used as x-values when Excel recognizes them as dates, but for elapsed time it can be simpler to use numeric intervals such as 0, 1, 2, and 3. Check that the y-values are numeric too, and decide how to handle blank or incomplete rows before charting.
  3. Select the two columns of data. Select both the x and y columns, including their headings. If the columns are next to each other, drag over the full range. If they are separated, select the first range, then hold Ctrl on Windows while selecting the second. On a Mac, use Command while selecting a non-adjacent range. If you have multiple y-series, it is often easier to insert the chart with the x-values and one y-series first, then add any other series separately.
  4. Insert an XY scatter chart. Go to Insert > Insert Scatter (X, Y) or Bubble Chart and choose the first Scatter option, which displays markers without connecting lines. This chart type treats the first selected column as numeric x-values and the next as y-values. A Line chart may space points evenly as categories, even when the x-values have different numeric intervals, so use Scatter when the spacing between x-values matters.
  5. Confirm the chart uses the intended ranges. Check that the horizontal axis shows your x-values and that the plotted markers match your observations. If Excel assigned the wrong column, select the chart and go to Chart Design > Select Data. In the Select Data Source window, choose the series and click Edit. Set Series X values to the x-value cells and Series Y values to the y-value cells, leaving out the heading cells. Click OK to apply the changes.
  6. Add a trendline. Click a marker for the data series you want to fit. On Windows, go to Chart Design > Add Chart Element > Trendline > More Trendline Options. You can also right-click the series and choose Add Trendline, then open more options in the formatting pane. If the chart contains multiple series, make sure you selected the intended series before adding the line; each series needs its own trendline.
  7. Choose a second-order polynomial. In the Format Trendline pane, select Polynomial, then set Order to 2. Excel updates the chart to show a quadratic curve. The order is important: order 1 is a straight line, while higher orders can bend more and may follow individual points too closely. For a quadratic trendline specifically, use order 2 rather than relying on an automatic setting.
  8. Show the equation or fit statistic if useful. In the Format Trendline pane, expand Trendline Options and select Display Equation on chart to show the fitted coefficients in the form y = ax² + bx + c. You can also select Display R-squared value on chart. The equation is useful for inspecting the fit, while R² summarizes how closely the curve matches the plotted values in this dataset. Neither tells you on its own whether the model is appropriate or predicts future results reliably.
  9. Make the chart readable and verify the result. Add a descriptive chart title and axis titles from Chart Design > Add Chart Element. Make the horizontal and vertical axis titles state the variables and units. If the curve or equation label overlaps the markers, drag the label to a clearer location. Confirm that the line follows the overall pattern rather than merely looking smooth, and check that no points were accidentally omitted from the series.

In Excel for Mac, the same chart and trendline options are available in current desktop versions, though ribbon layout and pane labels can vary slightly by release. Select the chart, use the Chart Design tab to add the trendline, and choose Polynomial with order 2 in its formatting options. In Excel for the web, chart editing features can differ; if the polynomial order control is unavailable, open the workbook in the desktop app to set it.

Common Mistakes

  • Choosing a Line chart instead of a Scatter chart. A Line chart can treat x-values as labels and give each point equal spacing. That distorts the relationship when the intervals are uneven. Use an XY Scatter chart when x-values are measurements, dates, or other numeric quantities whose distances matter.
  • Leaving the order at the wrong value. Selecting Polynomial alone may leave a default order that is not 2. Check the Order box explicitly. An order of 1 is linear; order 3 or higher is a different model and can create extra bends.
  • Including headings or totals as observations. Headings should identify series, not become data points. Totals and averages can also pull the curve away from the individual observations. Review the series ranges in Select Data if an unexpected marker appears.
  • Assuming a high R-squared proves the curve is right. A curve can match existing points closely and still be a poor explanation or forecast. Especially with few observations, a polynomial can overfit the data. Consider the real-world context and inspect the points, not only the statistic.
  • Using the displayed equation as if its rounded values were exact. Excel may show only a few decimal places. If you use the displayed coefficients for a calculation, increase the label’s decimal places and remember that rounding can still affect results. The displayed equation is for the fitted chart series, not a general-purpose substitute for checking the underlying data.

Tips

  • Keep the scatter markers visible. The markers show the observed data, while the trendline shows the fitted pattern. If you hide the markers, it is harder to see whether the quadratic curve is actually supported by the observations.
  • Use axis titles and units. A curve is easier to interpret when the reader can tell whether the axes represent time, distance, temperature, or another quantity. Include units where relevant, and avoid titles that merely repeat generic labels such as Series 1.
  • Compare against a linear fit. Add or temporarily select a linear trendline to see whether the quadratic bend materially improves the description. A slight visual improvement may not justify a more complicated model, particularly if the data has only a few points.
  • Use Forecast options cautiously. The trendline pane may let you extend a line forward or backward. This is a visual extension of the fitted curve, not evidence that the relationship will continue outside the observed range. A quadratic curve can rise or fall rapidly beyond the data, so keep any extension short and explain its limitations.
  • Separate multiple series clearly. If the chart has several groups, give each series a meaningful name and use distinct markers or colors. Apply a quadratic trendline to each series only when that comparison is relevant; a single curve should not be used to represent multiple unrelated groups.

Troubleshooting

The Polynomial choice or order box is missing. Click the plotted data series rather than the chart background or an axis, then reopen the trendline options. If the chart type does not support the option in your Excel release, change the chart to an XY Scatter chart and try again. In Excel for the web, open the workbook in desktop Excel if the available chart controls do not expose polynomial order.

The trendline looks straight even though order is 2. A quadratic curve can look nearly straight if the fitted coefficient for x² is small or the displayed axis range makes the bend hard to see. Check the scale and confirm the data range is correct. Do not change the axis scale just to make a tiny bend look dramatic; that can mislead readers.

The equation or R-squared label is not visible. Reopen Format Trendline and make sure the relevant display checkbox is selected. The label may be outside the chart area or hidden behind another object, so move it or enlarge the chart. If the equation is too small, resize the chart or adjust the label font and number format.

The line does not pass through every marker. That is expected. A trendline is a fitted curve and generally summarizes the pattern rather than connecting every observation. If the curve seems unrelated to the points, check the x- and y-series ranges, confirm the order is 2, and check for text values, blank rows, or an outlier that may strongly affect the fit.

The curve goes in an implausible direction outside the data. A quadratic polynomial can turn sharply beyond the observed x-range. Remove or reduce the forecast extension, and do not treat the extended curve as a dependable prediction without a suitable model and supporting evidence. If the bend itself is unexpected within the observed range, verify the data before interpreting it.

Frequently Asked Questions

What does a quadratic trendline mean in Excel?
A quadratic trendline is a polynomial curve of order 2, written as y = ax² + bx + c. It can model a pattern with one bend, unlike a straight linear trendline.

How do I make the trendline order exactly 2?
Select the data series, open More Trendline Options, choose Polynomial, and enter 2 in the Order box. Selecting Polynomial without checking the order does not guarantee that Excel is using a second-order curve.

Can I add a quadratic trendline to a Line chart?
Excel supports trendlines on several chart types, but an XY Scatter chart is the practical choice when your x-values are numeric and their intervals matter. A Line chart may treat horizontal values as equally spaced categories.

How many points do I need for a quadratic trendline?
At least three distinct x-values are needed to determine the three coefficients mathematically. In practice, use more observations when possible, because a curve based on only a few points is difficult to assess and can be strongly affected by one value.

Can I use the equation shown on the chart in another calculation?
Yes, but treat the displayed coefficients as rounded unless you increase their displayed precision. The equation describes the fitted series, and its use for prediction should be limited to a context where a quadratic model is justified.

Why does my quadratic trendline have a high R-squared but still look wrong?
R-squared describes the fit to the selected data; it does not confirm that the data range, model, or interpretation is appropriate. Check the series assignment, look for outliers, and consider whether a quadratic relationship makes sense before relying on the statistic.

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.