Share via

Trendline decimal places not changing when edited

unicorn475 0 Reputation points
2026-04-03T11:23:35.44+00:00

I have three trendlines on a graph on excel. It has let me change the number of decimal places on the first line using the 'format trendline label'. The other two lines when doing the exact same thing as before it wont let me change the number of decimal places. When I type 2 in and press enter, nothing happens

Microsoft 365 and Office | Excel | Other | Windows
0 comments No comments

1 answer

Sort by: Most helpful
  1. Arlene D 36,020 Reputation points Independent Advisor
    2026-04-03T12:12:26.1233333+00:00

    Hello,

    Are those two labels still the original equation labels or were they edited or copied at some point?

    When Excel does not change the decimal places, it usually means the label is no longer linked to the trendline format.

    Delete each affected trendline label, then turn it back on from Format Trendline by checking Display Equation on chart, and set the decimal places again under Number.

    This resets the label and allows the formatting to apply correctly.

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.