How to Display More Significant Figures in an Excel Chart Equation
Question details
The user needs to increase the number of significant figures displayed in the trendline equation (y=mx+b) on an Excel chart for better precision.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Analyzing chart data where precise equation coefficients are required for further calculations, but the default equation rounds the numbers.
- Observed behavior
- The trendline equation displays insufficient significant figures by default, and attempting to select or edit the text directly does not correctly update the equation's numerical precision.
Ensure your chart already has a trendline generated and that the 'Display Equation on chart' option is enabled so the equation text box is visible.
Format the Trendline Label Number Format
Change the number format of the trendline label directly to increase the decimal places and reveal all significant figures.
By default, Excel applies a 'General' number format to trendline equations, which limits the number of visible decimal places. Adjusting the label format to 'Number' or 'Scientific' allows you to specify the exact decimal precision required.
Click directly on the trendline equation text box displayed on your Excel chart to select it.
Right-click the selected equation box and choose 'Format Trendline Label' from the context menu.
In the formatting pane on the right side of the screen, locate the 'Number' section. Click the 'Category' dropdown and select either 'Number' or 'Scientific'.
In the 'Decimal places' box, type a higher number (such as 4, 5, or more) and press Enter. The chart equation will immediately update to display the additional significant figures.

Update Chart Data Range to Recalculate Equation
Expand your chart's source data range to include additional, more precise data points, forcing Excel to recalculate the equation.
Easily Format Chart Equations in WPS Spreadsheet
WPS Spreadsheet provides an intuitive interface for creating charts, adding trendlines, and customizing equation precision. It allows you to easily display more significant figures in a few clicks while remaining fully compatible with Excel files.
- 1. Open file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet containing the chart.
- 2. Add a Trendline Equation: Click your chart, select 'Chart Elements' (the plus icon), check 'Trendline', select 'More Options', and tick 'Display Equation on chart'.
- 3. Access Label Options: Double-click the newly added trendline equation on the chart to open the 'Format Trendline Label' pane on the right.
- 4. Increase Precision: Expand the 'Number' category, switch the format from General to 'Number', and adjust the decimal places to display your desired significant figures.

Frequently Asked Questions
Why does my Excel trendline equation show zero or heavily rounded numbers?
Excel uses a 'General' number format by default for chart labels, which aggressively rounds numbers with many decimal places. Changing the trendline label's format to 'Scientific' or increasing the decimal places in the 'Number' format will reveal the actual precise values.
Can I manually type a new equation on the chart to fix the numbers?
While you can technically click inside the equation box and edit the text manually, doing so disconnects the label from the chart data. If your underlying data changes in the future, your manually typed equation will not update.
How do I extract the exact trendline values into a spreadsheet cell?
Instead of relying on the chart label, you can use the LINEST function in your worksheet. Select an empty cell and enter =LINEST(known_y's, known_x's) to extract the exact slope and y-intercept values with maximum calculation precision.




