Chart & Visualization Issues

How to Format an Excel Trendline Equation on Mac

Huma Ashraf ChHuma Ashraf Ch Oct 23, 2026 870 views

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.

How to Format an Excel Trendline Equation on Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the equation

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.

2
Open the formatting pane

Right-click the selected equation text box and choose 'Format Trendline Label' from the context menu that appears.

3
Adjust the number format

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.

4
Set decimal places

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 the Trendline Label via the Context Menu
Selection Tip: If you do not see 'Format Trendline Label' upon right-clicking, you have likely clicked the chart background. Deselect by clicking outside the chart, then try clicking exactly on the text of the equation.
Easy Chart Formatting with WPS Office

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. 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your spreadsheet containing the chart and data.
  2. 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. 3. Access label formatting: Right-click the newly displayed equation text box on your chart and select 'Format Trendline Label'.
  4. 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.
Easily format trendline labels and equations without navigating complex menus.Fully compatible with Microsoft Excel (.xlsx, .xls) chart formats and formulas.Free, lightweight, and delivers fast performance on both Mac and Windows.Built-in advanced chart tools for professional and clear data visualization.
microsoft office alternative - wps office

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.