Share via

Trendline in Excel Online

Anonymous
2017-08-29T18:48:03+00:00

How can I add a trendlne to X-Y scatter graph and find the value of R^2 in Excel Online?

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
    2017-08-29T23:30:16+00:00

    Hello,

    some aspects of Excel can only be created in Excel for desktop. That includes adding a trendline to a chart. This cannot be done in Excel online. Edit the Excel workbook in Excel and add the trendline there. After that, you can open the workbook in Excel online and can see the trendline, but you can't create the trendline in Excel online.

    50+ people found this answer helpful.
    0 comments

Answer accepted by question author

  1. Anonymous
    2017-08-29T23:47:53+00:00

    Hi Mandal,

    Using Excel Online in a web browser looks a lot like the Excel desktop app. However, there are still some differences between them. For example, not all file formats are supported, and some features may not work or work differently than the desktop app. In Excel online, it is not feasible to add a trendline for a scatter graph. I suggest you upload your feedback via uservoice, this is the best way to let our related team know that.

    For more information:

    Differences between using a workbook in the browser and in Excel

    Regards,

    Linda

    20+ people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-08-29T19:17:14+00:00

    I can do everything in Excel 2016 offline application. But my school computers runs on Ubuntu. So, I use excel online. But failed to find any way to add the treadline(linear).

    0 comments
  2. Anonymous
    2017-08-29T18:56:24+00:00

    I cannot answer your question, since I do not use Excel Online.

    But you can calculate R^2 directly with a formula, if you wish.

    (If your intent is simply to display R^2 in the chart, this alternative will not be useful to you.)

    To demonstrate, it would be helpful to know the following information.

    1. What are the ranges of the X and Y data in the worksheet?
    2. What type of trendline are you using (linear, exponential, etc)?
    0 comments