Share via

How do I add a line of worst fit on a graph - Excel

Anonymous
2019-05-28T05:42:06+00:00

How can I add a line of worst fit onto a graph on excel? I currently have an expoential graph with an exponential trendline (Line of best fit) but I also need to add a line of worst fit and I'm unsure how to do so.

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
    2019-05-28T08:51:42+00:00

    Hi soupycarrots22,

    There is no a line of worst fit onto a graph in Excel. If the number of points is finite in your Excel, you can get a worse fit by shifting the line towards infinity (away from the points).

    On the other hand, you can use Error Bars to fit your requirement. Refer to this article for how to add that.

    Regards,

    Nina

    3 people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.7K Reputation points Volunteer Moderator
    2019-05-28T09:22:43+00:00

    Hi soupycarrots22

    Greetings! I am Vijay, an Independent Advisor. I am here to work with you on this problem.

    Do you have a link which describes the line of worst fit so that I can see whether it is feasible to make that or not?

    0 comments
  2. Anonymous
    2019-05-28T10:31:32+00:00

    Well our teacher gave us instructions on how to make the LOWF... but I am confused by it.

    4 people found this answer helpful.
    0 comments
  3. Jim G 134K Reputation points MVP Volunteer Moderator
    2019-05-28T17:28:13+00:00

    I think it is a trick question. There is no line of worst fit because you can always come up with a line that fits worse than the present line.

    0 comments
  4. Vijay A. Verma 104.7K Reputation points Volunteer Moderator
    2019-05-28T20:02:09+00:00

    This is very open as you don't know what to populate for x and y.

    0 comments