Excel Trendline Significant Digits: Set Equation Precision

Charts & pivot tables · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, change the digits shown in a trendline equation by selecting the equation label, opening Format Trendline Label, and adjusting its Number settings. This changes the equation’s displayed precision—not the precision of the regression calculations Excel uses behind the chart.

What “significant digits” means in an Excel chart

A trendline equation is a compact description of the relationship Excel has fitted to chart data. For a linear trendline, it might appear as y = 2.4x + 1.7. Those coefficients are rounded for display. Excel’s chart label does not provide a dedicated setting called “significant digits”; instead, its number-format controls let you choose how many decimal places to show or apply a number format such as scientific notation.

It helps to distinguish significant figures from decimal places. Decimal places count digits to the right of the decimal point. Significant figures count meaningful digits starting with the first nonzero digit. For instance, 0.004728 has four significant figures but six decimal places. A fixed decimal-place setting therefore does not give every coefficient the same number of significant figures.

The equation’s appearance is a presentation choice. If you show a coefficient rounded to two decimal places, Excel does not thereby change the fitted line to use that rounded value. However, someone who copies the printed equation and calculates with it is using rounded coefficients, which can produce different results.

Change the equation label’s number format

First make sure the chart displays a trendline equation. Select the chart, then use Chart Design > Add Chart Element > Trendline > More Trendline Options. In the Format Trendline pane, select Display Equation on chart. The exact trendline choices depend on the chart and the model you select.

To adjust the displayed digits in Excel for Microsoft 365 on Windows:

  1. Click the equation on the chart to select the equation label itself. Take care not to select the trendline or the chart area instead.
  2. Right-click the selected equation and choose Format Trendline Label. The Format Trendline Label pane opens.
  3. Expand Number, then choose a category such as Number or Scientific.
  4. For Number, set Decimal places to the amount you want. For Scientific, choose the displayed decimal places to control the digits after the leading digit.
  5. Close the pane and inspect the equation at the chart’s intended size. If the label becomes too wide or crowded, use fewer digits or enlarge the chart.

For example, Number with four decimal places may display a coefficient as 2.4167. A scientific format with three places after the decimal may show it as 2.417E+00. That scientific display has four significant figures: the leading 2 plus three digits after the decimal. The format changes the label’s appearance; it does not add more information to the fitted model.

On Excel for Mac, select the equation label and open its formatting pane from the context menu; the available chart-formatting controls are similar, though the interface and pane layout can differ. Excel for the web may offer fewer chart-formatting controls than the desktop application, so use desktop Excel if you cannot find the label’s Number settings.

Decimal places are not the same as significant figures

A fixed decimal format can be useful when coefficients are on a similar scale. But it can mislead when one coefficient is large and another is tiny. With four decimal places, 0.000037 becomes 0.0000, while 12.34567 becomes 12.3457. The first coefficient appears to be zero even though it is not; the second retains many digits that may not be useful.

Scientific notation is often a better choice when the coefficients span very different magnitudes. In a format such as 0.000E+00, the number is shown with one digit before the decimal point and three after it, giving four significant figures for nonzero values. A coefficient of 0.00003726 can then be displayed in a form such as 3.726E-05 rather than being rounded to zero at a fixed number of decimal places.

For an ordinary report, choose the format that makes the coefficient easy to read without implying unjustified accuracy. If the chart needs familiar units, fixed decimals may be clearer. If values are very small or vary widely in size, scientific notation can preserve useful digits. Excel’s chart-label formatting does not automatically apply a consistent significant-figures rule to every coefficient in the equation.

Displayed rounding versus calculation precision

Excel rounds the equation shown on the chart to fit its number format, but the trendline calculation is based on the underlying chart data, not just the digits visible in that label. This distinction matters if you use the equation to estimate a value. Substituting a value into the short equation copied from the chart can give a slightly different result from the trendline because the copied coefficients are rounded.

The difference can become more noticeable when you use the equation far beyond the range of the observed data. Even a small coefficient difference can have a larger effect at a distant x-value, especially for a polynomial trendline. That does not mean the chart’s displayed equation is broken; it means a rounded label is not a substitute for the full-precision model.

If you need precise calculations, keep the source data and calculate the model from the data in worksheet cells or use a method designed for your analysis. Do not treat a chart equation with a few visible digits as a full-precision forecasting formula. For a presentation, the rounded equation may be perfectly adequate as a visual summary, provided its purpose is clear.

How many digits should you show?

There is no universally correct number of digits. The right choice depends on the data’s measurement quality, the chart’s audience, and what readers are expected to do with the equation. Showing more digits can make a label look precise without making the underlying measurements or model more reliable.

  • For a quick visual summary: use enough digits to show the overall slope and intercept clearly, often a few decimal places when values are on a similar scale.
  • For coefficients with very different sizes: try scientific notation so small values do not disappear through rounding.
  • For a published analysis: choose precision consistent with the measurements and explain how the model was fitted. Avoid suggesting that rounded coefficients are exact.
  • For calculations or forecasts: do not rely on the shortened equation label. Use a calculation based on the original data and appropriate full-precision coefficients.

For example, suppose a chart’s linear equation is displayed as y = 0.0000x + 5.2381. A reader may infer that x has no effect. The actual slope might simply be small relative to the chosen decimal format. Scientific notation could make that slope visible, but it should still be interpreted in the context of the x- and y-units. A tiny coefficient is not automatically important or unimportant; the scale of the variables matters.

Equation labels, R-squared, and chart readability

Excel can also display an R-squared value alongside the equation. To add it, open the trendline options and select Display R-squared value on chart. R-squared describes how well the fitted trendline accounts for variation in the data under the model’s assumptions; it does not establish that the model is appropriate, that the relationship is causal, or that future predictions will be accurate.

The equation and R-squared appear together as chart text, so formatting the label can affect how its numeric content is presented. Check both parts after changing the Number settings. If the R-squared value needs a different precision from the coefficients, the equation label may not give you independent formatting controls for every number. In that case, consider placing a separately formatted value in a text box or in a worksheet cell, and make its meaning clear.

Keep the chart legible. A long polynomial equation with many digits can overwhelm the data and make the chart difficult to read. It is often better to show a concise equation on the chart and provide detailed coefficients or methods in a nearby table or note when the audience needs them.

Common problems and how to fix them

  • The Number section is missing: check that you selected the equation label, not the trendline, legend, or chart area. Right-click the equation text and choose Format Trendline Label.
  • A small coefficient displays as zero: increase the decimal places or try scientific notation. A zero in the formatted label can be a rounding effect, not proof that the fitted coefficient is exactly zero.
  • The equation changes after changing chart data: Excel refits the trendline when the included data changes. Formatting controls how the updated result is displayed; it does not lock the equation to its former coefficients.
  • The equation does not match a hand calculation: check whether you used rounded label values, the same data points, and the same model. Also confirm that the chart’s x-values are being treated as numeric values where that is required.
  • The label is too long: reduce the displayed precision, move or resize the label, or use a separate table for detailed values. Adding digits is not always an improvement.

One related chart issue is the choice of chart type. An XY (Scatter) chart uses numeric x-values, which is generally appropriate when fitting a relationship against measured x-values. A Line chart can treat its horizontal axis as categories rather than as a continuous numeric scale. If the trendline seems inconsistent with the spacing of your x-values, check the chart type and axis interpretation before trying to fix the equation’s digits.

Frequently Asked Questions

Can I set Excel to show exactly four significant figures?
There is no dedicated significant-figures setting for a trendline equation label. Scientific notation can give a consistent number of significant figures for nonzero coefficients: for example, 0.000E+00 shows one leading digit plus three decimal digits. A fixed decimal-place format does not give consistent significant figures when values have different magnitudes.

Does changing decimal places change the trendline?
No. It changes the equation label’s number format, not the data or the fitted trendline. The displayed coefficients are rounded for presentation, so calculations based on the visible equation may differ slightly from the model’s full-precision result.

Why does my trendline equation show a coefficient as zero?
The coefficient may be nonzero but too small to appear at the selected number of decimal places. Increase the displayed precision or use scientific notation, then consider whether the coefficient is meaningful at the scale of your variables.

Can I copy the equation from the chart for accurate predictions?
You can use it for rough estimates, but the equation label may contain rounded coefficients. For accurate work, calculate from the original data or use full-precision model values rather than treating the printed label as exact.

Can I format the equation and R-squared separately?
The equation and R-squared are displayed in the trendline label, and its number-format settings may apply to the label’s numeric content rather than giving independent precision controls for each item. If they need different formats, present one value separately in a clearly labeled text box or worksheet cell.

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.