Share via

Adding a trendline to a scatterplot

Anonymous
2021-02-06T00:29:58+00:00

This should be really simple, right? I'm trying to add a trendline to my scatterplot of Distance Measured vs Wavelength for my chemistry class, but I can't find the + sign that I'm supposed to click that should let me add a trendline. I'm really confused. Google Sheets is so much easier D:

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2021-02-06T08:39:03+00:00

    Hi Aidankraus,

    I agree it’s easy to add the trendline to the chart in the Excel but since you mentioned you can’t see the + symbol beside the chart, we would like you to try the below steps and check the outcome:

    Open the Excel file with scatter chart> Click on the Chart> Chart Design in the Ribbon> Add Chart Element in the Chart Layouts sections> Trendline.

    If you cannot see the Add Chart Element in the Chart Design tab, please try to remove the chart inserted and re-insert the chart to check the outcome.

    Please share us the updates after giving a try and we will keep assisting you further on the concern you are facing.

    Best Regards,

    Chitrahaas

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-02-09T19:26:34+00:00

    Hi Aidankraus,

    Please let us know if there are any updates at your end.

    Thanks,

    Chitrahaas

    0 comments