How to Format an Excel Trendline Equation on Mac
Question details
The user needs to change the number format of a trendline equation in an Excel chart to display specific decimal places instead of scientific notation.

- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Presenting or analyzing data charts where the automatically generated trendline equation defaults to scientific notation.
- Observed behavior
- The trendline equation displays numbers in scientific notation (such as 1E-06x), making it difficult to read precise decimal values.
Ensure your chart already has a trendline and an equation displayed. If your chart elements are small, consider using the zoom slider to temporarily enlarge the chart so you can accurately click the equation box rather than the entire chart area.
Format the Trendline Label via the Context Menu
This is the most direct method to adjust the number formatting of your trendline equation and replace scientific notation with specific decimal places.
A common mistake is accidentally selecting the entire chart instead of the specific equation label. Zooming in and ensuring only the text box is highlighted is crucial for the correct formatting options to appear.
Position your pointer directly over the trendline equation box on the chart and click it once. Verify that selection handles appear only around the equation text, not the entire chart or the trendline itself.
Right-click the selected equation text box and choose 'Format Trendline Label' from the context menu that appears.
In the formatting pane that opens on the right side of your screen, navigate to the 'Number' section. Select the 'Number' category from the dropdown menu.
Locate the 'Decimal places' input field, type in your desired number of decimal places (for example, 3), and close the formatting pane to apply the changes.

Format Trendline Equations Easily in WPS Spreadsheet
WPS Spreadsheet offers a seamless and free way to manage charts, trendlines, and complex data visualizations. It features a highly intuitive interface for formatting chart elements on Mac and Windows while maintaining perfect compatibility with Microsoft Excel files.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet containing the chart and data.
- 2. Display the trendline equation: Double-click your chart's trendline to open the settings pane, and check the box for 'Display Equation on chart'.
- 3. Access label formatting: Right-click the newly displayed equation text box on your chart and select 'Format Trendline Label'.
- 4. Customize the decimals: In the right-hand panel, go to the Number tab, change the category to Number, and specify your desired decimal places.

Frequently Asked Questions
Why is my trendline equation showing scientific notation like 1E-06x?
Excel automatically uses scientific notation for very small or very large coefficient numbers in trendline equations to save space on the chart. Formatting the label category as 'Number' overrides this default behavior.
I can't find the 'Format Trendline Label' option when I right-click. What's wrong?
You likely have the entire chart area or the trendline itself selected instead of the equation text box. Ensure you position your cursor directly over the equation text and click it before right-clicking.
Can I change the font size and color of the trendline equation?
Yes. Once the trendline label is selected (indicated by the box around the text), you can use the standard font formatting tools found in the Home ribbon tab to change the font size, color, and weight.
Does this number formatting apply to the R-squared value as well?
Yes. If the R-squared value is displayed within the same label box as the equation, formatting the trendline label's number category will apply the specified decimal places to both the equation coefficients and the R-squared value.




