Excel Exponential Trendline Formula and How to Use It

Charts & pivot tables · Updated November 19, 2026

The exponential trendline model is y = a ebx, where a is the value predicted when x is zero and b controls the rate of change. In Excel, add an Exponential trendline to an XY scatter chart to see its equation, or calculate the same kind of fit in worksheet cells by regressing the natural logarithm of y against x.

What an exponential trendline means

An exponential model describes change by a roughly constant percentage over equal steps in x, rather than by a constant amount. If a quantity grows by 50% each period, for example, its values can follow 10, 15, 22.5, 33.75. The increases get larger, even though the percentage increase stays the same.

In the model y = a ebx, e is the mathematical constant approximately equal to 2.718. The parameter a sets the starting scale: at x = 0, the model predicts y = a. The parameter b is the continuous growth rate per x-unit. A positive b means growth; a negative b means decline. The percentage change per one x-unit is eb − 1.

Excel may show the chart equation with different coefficient letters, such as y = c·ekx. The names are not important; identify the coefficient outside the exponential as the starting level and the coefficient multiplying x in the exponent as the rate parameter. Do not confuse this chart equation with a worksheet function: Excel does not automatically place the trendline equation in a cell when you display it on a chart.

How Excel fits the model

The model can be rearranged by taking the natural logarithm of both sides: ln(y) = ln(a) + bx. This is a straight-line relationship between x and ln(y). Excel can therefore estimate the exponential curve by fitting a linear regression to transformed y values. The fitted line’s slope is b, and its intercept is ln(a); applying EXP to that intercept gives a.

This explains an important restriction: every y value used in an exponential fit must be greater than zero, because ln(0) and the natural logarithm of a negative number are not real numbers. Zero or negative y values cannot be used in Excel’s exponential trendline. The x values need to be numeric, but they do not have to be positive. If your data include zero or negative outcomes, consider another model rather than changing those values merely to make the chart accept them.

Calculate the trendline in worksheet cells

A worksheet calculation is useful when you need forecasts in cells, want to retain full-precision coefficients, or need to audit the calculation. Set up a small example with x values in A2:A6 and positive y values in B2:B6: (0, 10), (1, 15), (2, 22.5), (3, 33.75), and (4, 50.625). This example increases by 50% per x-unit, so the fitted model should start at 10 and predict 75.9375 when x is 5.

  • With x in A2:A6 and positive observed y values in B2:B6, enter the following in C2 to transform the first y value; fill it down through C6. Column C then contains ln(y).

=LN(B2)

  • With x in A2:A6 and the transformed values in C2:C6, enter this in E2 to calculate the slope, which is the model’s b.

=SLOPE(C2:C6,A2:A6)

  • With the same x and transformed-y ranges, enter this in E3 to calculate the intercept ln(a).

=INTERCEPT(C2:C6,A2:A6)

  • With the intercept in E3, enter this in E4 to convert ln(a) back to the starting value a.

=EXP(E3)

For the example, E2 is approximately 0.405465, E3 is approximately 2.302585, and E4 is 10. The slope is ln(1.5), so converting it back to a per-unit percentage change gives 50%. With the slope in E2, the following formula returns that percentage as a decimal; format the result as Percentage if you want to display 50%.

=EXP(E2)-1

To calculate a fitted value for a particular x, put that x in G2. With a in E4 and b in E2, enter the following in H2. For G2 equal to 5, it returns 75.9375.

=$E$4*EXP($E$2*G2)

The dollar signs keep the coefficient references fixed if you copy the forecast formula down a column. Replace the example ranges with your own data ranges, keeping the x and y observations paired row by row. If there are blank cells, text entries, or errors in either series, clean or exclude those observations before interpreting the coefficients.

Add an exponential trendline to a chart

A chart is the quickest way to inspect the curve and display Excel’s equation. On Excel for Microsoft 365 on Windows, arrange x and y in two columns, select both columns, and choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter. Use an XY scatter chart rather than a line chart when the x values represent numeric distances or times; a line chart can treat the horizontal positions as categories instead of true numeric values.

  1. Select the plotted data series, then choose Chart Design > Add Chart Element > Trendline > More Trendline Options.
  2. In the Format Trendline pane, select Exponential.
  3. If you want the equation on the chart, select Display Equation on chart. Select Display R-squared value on chart if you also want Excel to show that statistic.

Chart equation labels are rounded for display, so copying their visible coefficients into a forecast can cause small differences, especially for larger x values. Use worksheet calculations when you need more precision. On Excel for Mac, the chart and trendline options are available, though ribbon placement and pane layout can vary by release; select the chart and look for the Chart Design trendline controls or the Format Trendline pane. Excel for the web can display and edit many chart features, but if an option is missing in your version, open the workbook in desktop Excel to access the full chart formatting controls.

Read the equation and assess the fit

Check the units before interpreting the coefficients. If x is measured in days, b is per day; if x is measured in years, b is per year. Changing the scale of x changes the numerical value of b even though the underlying curve can represent the same data. The starting value a is the model’s estimate at x = 0, which may be outside the observed range. In that case it is an extrapolated intercept, not necessarily a measured starting point.

The chart’s R-squared value is a summary of fit, not proof that exponential behavior is the right explanation. Look at the scatterplot and compare predicted values with observed values. A pattern in the residuals—the differences between observed and predicted y—can reveal systematic underestimation or overestimation that a single fit statistic hides. Also consider whether the process has a plausible reason to maintain a similar percentage rate over the range you are analyzing.

Do not read b itself as the percentage growth rate. For example, if b is 0.405465, the per-unit multiplier is e0.405465, or 1.5, which corresponds to 50% growth per x-unit. This distinction matters for negative rates too: a negative b indicates decline, while the exact percentage change is still calculated as eb − 1.

Choose between exponential and other trendlines

An exponential trendline suits data that change by a relatively stable percentage over equal x-intervals. A linear trendline instead represents a roughly stable additive change: the increase might be 5 units each period. A power trendline models a relationship of the form y = a·xb and is often considered when both variables are positive and the relationship is multiplicative. A polynomial trendline can follow curves that bend direction, but its flexibility can make it fit noise rather than a meaningful pattern.

Compare candidate models using the data’s context, a plot, and errors on the original y scale. An exponential fit is especially questionable when it predicts unrealistic growth or decline far beyond the observed x range. Forecasting a short interval beyond measured data is different from assuming a constant percentage rate indefinitely; real processes may encounter limits, changing conditions, or measurement constraints.

Common problems and fixes

  • Excel will not add the trendline: check for zero or negative y values, since an exponential fit requires positive y observations.
  • The curve looks wrong: verify that x and y are paired correctly and that the chart is an XY scatter chart. Check whether the x values are numbers rather than text.
  • The displayed equation does not reproduce a chart point exactly: the chart label rounds its coefficients. Calculate coefficients in cells for more precision.
  • The coefficient seems unlike a percentage: b is a continuous rate parameter, not the per-step percentage. Convert it with eb − 1.
  • The fitted intercept seems implausible: x = 0 may lie well outside the observed range. Consider shifting x by subtracting a meaningful reference value, and clearly document that the intercept then refers to that reference point.

Frequently Asked Questions

What is the Excel exponential trendline formula?
The mathematical model is y = a·ebx. In a worksheet, calculate b by applying SLOPE to ln(y) and x, calculate ln(a) with INTERCEPT, then apply EXP to that intercept. The chart can display its fitted equation when you enable Display Equation on chart.

Can an exponential trendline include zero or negative values?
No. Excel’s exponential trendline requires positive y observations because fitting it uses the natural logarithm of y. Do not replace zeros or negative values with arbitrary small positive numbers; that changes the data and the resulting fit.

How do I calculate an exponential forecast in Excel?
Once you have the fitted a and b coefficients, evaluate a·EXP(b times the new x value). Keep the coefficient cells fixed when filling the formula down, and avoid relying on rounded coefficients copied from a chart label.

How do I find the percentage growth rate?
For a model written as y = a·ebx, the percentage change for one x-unit is 100·(eb − 1) percent. If x represents months, this is the model’s per-month percentage change; a different x-unit gives a different rate interval.

Why does my chart equation differ from my worksheet result?
Excel rounds the equation shown on the chart, and small coefficient differences can become more noticeable at distant forecast x values. Make sure both calculations use the same observations and x values, then use unrounded worksheet coefficients for calculations.

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.