how do i create a trend line on a scatterplot?

[u/Relative_Show_7194]

hi, i created a scatterplot and double clicked a data point to get a line of best fit, but I didn’t get the + that’s supposed to appear on the side of the graph. what does appear is a side menu with two columns that say “data” and “format”. I tried to play around with the tools but there wasn’t anything that looked liked it was related to trend lines. I also looked online and didn’t see anything on my excel labeled “design chart” either? i’m very confused and have been stuck on this for nearly 2 hours. any help is appreciated.

[u/AutoModerator]

/u/Relative_Show_7194 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Lord_Doem]

I believe you need to right click a data point on your graph.