To increase the decimal places in an Excel trendline equation, select the equation label on the chart, right-click it, choose Format Trendline Label, then open Number and choose a number format with more decimal places. This changes how the equation is displayed; it does not change the trendline calculation or make the model more accurate.
Show the trendline equation first
If the chart does not show an equation yet, add a trendline and turn on its equation label. In Excel for Microsoft 365 on Windows, select the chart, then go to Chart Design > Add Chart Element > Trendline > More Trendline Options. In the Format Trendline pane, select the appropriate trendline type and check Display Equation on chart. You can also check Display R-squared value on chart if you want that statistic shown.
Excel places the equation on the chart as a label. Its position and appearance can be adjusted separately from the trendline itself. If the equation is already visible, you can skip the trendline setup and format the label directly.
Increase decimal places in the equation label
Make sure you select the equation text, not the line or the chart area. If you select the line, Excel opens the trendline formatting options instead of the label’s number formatting. On Windows, right-click the equation and select Format Trendline Label. Alternatively, select the label and press Ctrl+1 to open its formatting pane.
- In the formatting pane, expand Number.
- Choose Number as the category if you want a fixed number of decimal places.
- Increase Decimal places to the number of digits you want to show.
- If Linked to source is selected and prevents the format you want, clear it, then set the number format.
For example, choosing four decimal places can display a coefficient as 1.2346 instead of 1.23. The equation label may contain more than one number, such as the slope and intercept, so the same number format can affect both. Check the complete equation after applying the change.
What the decimal-place setting changes
The equation label is a formatted display of the trendline parameters. Increasing its decimal places reveals more of the values Excel calculated; it does not add observations, alter the selected trendline type, or recalculate the chart using a different method. The underlying trendline is still based on the chart’s data and the selected model.
This distinction matters when using the printed equation for a manual estimate. Suppose Excel’s underlying values are approximately a slope of 1.234567 and an intercept of 0.987654. A label rounded to two decimal places might show y = 1.23x + 0.99. At x = 100, that displayed equation gives 123.99, while the unrounded parameters give about 124.444354. The difference comes from rounding the coefficients, not from changing the data or trendline.
More displayed digits can make an equation more useful for checking or copying approximate coefficients, but they are not a guarantee of unlimited precision. A chart label is a convenient summary, not necessarily the best place to obtain values for calculations that require strict reproducibility.
Choose a suitable number format
For most charts, the Number category with a fixed decimal count is the clearest choice. Two or three decimal places may be enough for a simple report, while a small coefficient or an equation used for an estimate may need more. Avoid adding digits simply because the option allows it: a long string of decimals can make a chart harder to read and can imply more certainty than the data supports.
If the values are very large or very small, consider whether ordinary decimal notation is appropriate. A Scientific number format can make a very small coefficient readable, though it may be less familiar to some readers. You can also choose Custom and enter a format code such as 0.0000 to show four decimal places. A custom format changes presentation; it does not change the stored or fitted value.
- Use a small, consistent number of places when the equation is mainly for a chart audience.
- Show more places when readers need to inspect or reuse the fitted coefficients.
- Use scientific notation when fixed decimals would produce a long run of leading or trailing zeros.
- Keep the equation label large enough to read after adding digits, and reposition it if it overlaps data.
Why extra digits do not mean greater accuracy
Displayed precision and statistical accuracy are different. A trendline can show six decimal places even when the observations are noisy, the relationship is weak, or the chosen model is unsuitable. More digits only make the displayed coefficient more detailed. They do not make the assumptions behind the fit more valid.
Consider the chart’s context: how the data was collected, whether the relationship looks linear, whether outliers are influential, and whether the trendline is being used to describe observed data or extrapolate beyond it. The displayed R-squared value can help describe how closely a fitted line corresponds to the plotted data, but it does not establish that the model is appropriate or that a prediction is reliable. It is best treated as one piece of context rather than a quality stamp.
For important calculations, use the underlying data and an appropriate worksheet calculation or statistical workflow rather than copying rounded values from a chart. If you do use the chart equation, show enough decimal places for the purpose and explain that the coefficients are rounded display values.
Common problems and fixes
- The Number section is missing: You may have selected the trendline rather than the equation label. Click the equation text itself, then open Format Trendline Label.
- The equation still looks rounded: Confirm that you changed the label’s number format, not the worksheet cells or axis labels. Also check whether Linked to source is enabled.
- Only some digits seem to change: The equation contains separate numeric values, and the label format may not present them exactly as expected. Try the Number category with a fixed decimal count, then inspect both the slope and intercept.
- The equation switches to scientific notation: Excel may be using a format suited to the value’s size. Choose Number or a suitable custom format if ordinary decimals are easier to read.
- The label overlaps the chart: Select and drag the equation label to a clearer position, or resize the chart. More digits make the label wider.
If the controls still do not match these steps, confirm that the selected object is the equation label and that you are editing the chart in desktop Excel. Ribbon layouts and available chart controls can vary by platform and update.
Trendline decimals versus axis decimals
Changing the equation label’s decimals does not change the numbers shown on the horizontal or vertical axis. Those are separate chart elements with their own number formats. To change an axis, select the axis labels, open Format Axis, and use the Number section in that pane. Likewise, formatting the source cells does not automatically mean that the equation label will display the same number of decimal places.
This is a common source of confusion: the plotted points, the axis tick labels, the trendline equation, and the R-squared label are distinct parts of the chart. Format the specific part whose appearance you want to change. If the goal is to show more precise values in the data table or worksheet, format those cells separately.
Windows, Mac, and Excel for the web
The instructions above describe Excel for Microsoft 365 on Windows. In Excel for Mac, select or Control-click the equation label and open its formatting options; the pane and ribbon arrangement may differ, but look for the label’s Number settings. Right-clicking can also work if your mouse or trackpad is configured for a secondary click. Keyboard shortcuts can vary by Mac setup, so using the context menu is a straightforward alternative.
Excel for the web has a different interface and may not expose every chart-formatting control in the same place as desktop Excel. If you cannot find the equation label’s number settings in the browser, open the workbook in the desktop app and format the label there. The change is a chart-formatting change, so save the workbook after editing and check that the displayed equation remains legible.
Frequently Asked Questions
Can I show more than two decimal places in an Excel trendline equation?
Yes. Select the equation label, open Format Trendline Label > Number, and increase the decimal places. If needed, clear Linked to source before setting the format.
Does increasing decimal places change the trendline?
No. It changes the equation label’s display format, not the fitted trendline or its calculation. It reveals more digits of the coefficients in the label.
Why does my trendline equation not match my chart values exactly?
The label may round its coefficients. Substituting values into a rounded equation can produce a slightly different result from calculations based on the fuller coefficients, especially for larger x-values.
How do I make the trendline equation show more digits in Excel for Mac?
Select or Control-click the equation label, open its formatting options, and look for Number. The location and appearance of controls can differ from Windows; if the setting is unavailable, try Excel for desktop with the latest available updates.
Will changing the axis decimals also change the equation?
No. Axis labels and the trendline equation are formatted separately. Select the equation label to format its coefficients, or select an axis to format its tick labels.
Related
- Excel Solver: How to Save and Reuse Solver Scenarios
- Excel Solver Not Installed? How to Enable It
- Excel Solver Not Responding? Fixes and Causes
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Sort Pivot Tables in Google Sheets: Steps and TipsTo sort a pivot table in Google Sheets, click inside it and use the Pivot table editor: under…
- Google Sheets Data Chart: Create, Customize, and Fix ItTo make a data chart in Google Sheets, select the cells you want to visualize, then choose Insert…
- Excel Pivot Table: Hide Filter Buttons, Keep FiltersTo hide the filter buttons in an Excel PivotTable without clearing its current filter selections, click anywhere in…
- How to Make a Stacked Bar Chart in ExcelTo make a stacked bar chart in Excel for Microsoft 365 on Windows, arrange categories in the first…
- Access Power Pivot Add-In: Use Access Data in ExcelYou cannot add Power Pivot to Microsoft Access: Power Pivot is an Excel add-in, not an Access feature.…
- Data Pivot Chart: Meaning, Uses, and How It Works in ExcelA data pivot chart—usually called a PivotChart in Microsoft Excel—is an interactive chart linked to a PivotTable. It…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.