Excel Trendline Equation: Show More Decimal Places

Charts & pivot tables · Updated November 21, 2026

To show more decimal places in an Excel trendline equation, select the equation label, open Format Trendline Label, and use the Number settings to increase Decimal places. This changes how the coefficients are displayed, not the trendline calculation or the underlying precision of the chart.

Show more decimal places in Excel

In Excel for Microsoft 365 on Windows, add a trendline and display its equation if you have not already done so. Then format the equation label itself:

  1. Select the chart, then select the trendline equation label. If the first click selects the chart or the trendline, click the equation text again to select the label.
  2. Right-click the equation label and choose Format Trendline Label. Excel opens a formatting pane.
  3. In the pane, expand Number. Choose Number as the category and enter the number of decimal places you want.
  4. Close the pane or click elsewhere in the chart to see the updated equation.

For example, changing the setting from two decimal places to six can change a displayed coefficient from 2.01 to 2.013700. The exact appearance depends on the data and the coefficient. If you want trailing zeroes to remain visible, use a custom number format such as 0.000000, where the zeroes specify six decimal places. Avoid adding more digits than readers can usefully interpret.

If you cannot select the equation label, first make sure the trendline option to display the equation on the chart is enabled. Right-click the trendline, choose Format Trendline, and look for the equation display option in the trendline settings. The equation label is a separate chart element from the line, so selecting the line alone will not expose the label’s number formatting controls.

What the decimal setting changes

The equation printed on a chart is a formatted label. Its displayed digits are rounded for readability; they are not a limit on the precision Excel uses to calculate the trendline. Increasing the decimal-place setting reveals more of the calculated coefficients in the label. It does not alter the data, recalculate a different model, move the plotted trendline, or change the chart’s R-squared value.

This distinction matters when someone reads the equation from the chart and uses it to calculate a prediction. If the label shows a slope rounded to 2.01, calculations based on that short value can differ slightly from predictions based on Excel’s more precise coefficient. Showing extra decimals reduces that discrepancy, but the chart label is still intended as a presentation aid, not necessarily as the best place to retrieve a coefficient for further analysis.

Changing the decimal places also does not make a weak trend more reliable. A line with a coefficient displayed to ten decimal places can still be a poor description of the observations. Consider the sample size, data quality, residual pattern, and suitability of the trendline type as well as the number of digits shown.

How many decimal places should you show?

There is no universally correct number. Choose enough digits to make the displayed equation useful for the chart’s purpose, while avoiding a false impression of certainty. A presentation chart might need two to four decimal places; a technical report may need more if small differences in coefficients affect the calculations. Match the precision to the measurement scale and the precision of the source data.

Useful factors to consider include:

  • How the equation will be used: A rough visual summary needs fewer digits than a coefficient copied into a calculation.
  • The scale of the data: A slope near 0.0004 may appear as zero with too few decimal places, while a slope near 400 may not need many.
  • Measurement precision: Reporting a highly precise coefficient does not make rounded or noisy measurements more precise.
  • Chart readability: Long equations can overlap data, legends, or other labels. Resize the chart or move the label if necessary.

As a practical check, compare predictions made with the displayed equation against predictions from the original data or full-precision coefficients. If the difference is immaterial for the decision at hand, extra digits may add clutter without adding value.

Get coefficients for calculations

If you need the regression coefficients in worksheet cells, calculate them from the same known x and y values instead of transcribing the rounded chart label. For a simple linear trendline, Excel’s SLOPE and INTERCEPT functions return the slope and y-intercept. Format those result cells to show as many decimals as you need; changing the cell format changes the display, not the stored result.

For example, suppose x-values are in A2:A5 and y-values are in B2:B5, with the pairs (1, 2.1371), (2, 4.1508), (3, 6.1645), and (4, 8.1782). With those values in the stated ranges, enter =SLOPE(B2:B5,A2:A5) to return 2.0137. With the same layout, enter =INTERCEPT(B2:B5,A2:A5) to return 0.1234. The resulting linear equation is y = 2.0137x + 0.1234. These values form an exact line for this illustrative dataset, so the chart’s linear trendline should have those coefficients before label rounding.

To display more digits in the worksheet results, select the cells and use Home > Number to increase the decimal places, or open Format Cells and choose a number format. These cell settings are independent of the equation label’s settings: formatting the worksheet cells does not automatically change the chart label, and formatting the label does not change the cells.

For polynomial, logarithmic, exponential, or power trendlines, do not assume the simple linear functions above supply every coefficient in the displayed equation. The regression model and its coefficient structure differ. If you need to reproduce a more complex model in worksheet formulas, identify its trendline type and build the corresponding calculation rather than copying a linear formula.

Common problems and fixes

  • The Number section is missing: Check that the equation label, rather than the trendline or chart area, is selected. The formatting pane changes according to the selected chart element.
  • The equation still looks rounded: Confirm that the decimal-place setting was changed in the label’s Number section. If a custom format is used, verify that it has the intended number of zero placeholders.
  • Extra digits appear as zeroes: A format with fixed decimal places can add trailing zeroes. Those zeroes are formatting, not evidence that the measured data were recorded to that precision.
  • The label shows scientific notation: A coefficient that is extremely small or large may be easier to read with an appropriate number format or in a worksheet cell. Check that the format still communicates the scale clearly.
  • The equation is hard to read: Move the equation label, enlarge the chart, or reduce the number of displayed decimals. More digits can make an equation overlap other chart content.

Another common misconception is that increasing decimals improves the fit. It does not. The trendline’s fit is determined by the data and selected model. More decimals only make the displayed coefficients less rounded. If the line itself looks wrong, inspect the selected x- and y-ranges, check for unexpected blanks or text, and confirm that a linear model is appropriate before adjusting the label.

Trendline type and equation meaning

The equation format depends on the trendline type. A linear trendline is shown in the general form y = mx + b, with slope m and intercept b. A polynomial trendline includes powers of x, while exponential, logarithmic, and power trendlines use different mathematical forms. A decimal-place setting can make the coefficients in these equations easier to read, but it does not change the model form.

Be careful when interpreting the equation outside the chart. A trendline equation describes the fitted relationship for the plotted data; it does not guarantee that the relationship continues beyond the observed range. Extrapolating far past the data can produce misleading predictions, particularly for curved trendlines. Also, the displayed R-squared value is a separate statistic: showing more decimals in the equation does not, by itself, increase the model’s explanatory power.

Windows, Mac, and Excel for the web

The steps above are for Excel for Microsoft 365 on Windows. In Excel for Microsoft 365 on Mac, select or Control-click the equation label and open its formatting options; the pane may be arranged differently, but look for the label’s Number settings and decimal-place control. A right-click may also work, depending on the mouse or trackpad settings.

Excel for the web may offer fewer chart-formatting controls than the desktop application, and the exact options can vary. If you do not see number formatting for the trendline equation label in the browser, open the workbook in the desktop Excel app and change the label there. The formatting change is part of the chart, so save the workbook after editing it.

Frequently Asked Questions

Can I show more than two decimal places in a trendline equation?
Yes. Select the equation label, open Format Trendline Label, and increase the decimal places under Number. You can also use a custom number format when you need a fixed number of visible decimal places.

Does showing more decimals change the trendline?
No. It changes the label’s appearance, not the fitted line, source data, or regression calculation. It also does not change R-squared.

Why does my equation still give a different answer from the chart?
The displayed equation may round its coefficients. Use worksheet regression functions or a suitable regression calculation for full-precision coefficients, and make sure you use the same data and trendline model as the chart.

Can I show more decimal places for only one coefficient?
The number format is applied to the equation label as a whole, rather than being a separate precision control for each coefficient. If the coefficients need different presentation formats, use a separate text label or construct a displayed equation from worksheet values.

Why does Excel show extra zeroes?
A fixed-decimal format such as 0.000000 displays six places even when some are trailing zeroes. That is a display choice; it does not mean the underlying observations were measured to six decimal places.

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.