How to add line/curve of best fit to scatter plot in Microsoft Excel

  • Post category:Tools

If you have to generate a scatter plot in Microsoft XLSX spreadsheet and want to add the line of best fit for the points on your plot, here are the steps you can follow:

  1. Copy your x-data and y-data in a spreadsheet. Select x-data and y-data, click on “Insert” in the menu and then select scatter plot from the “Charts” area.How to add line/curve of best fit to scatter plot in Microsoft Excel
  2. Click on the plot to get “Chart Elements”. “Chart Elements” will have “Trendline”. Select that and it will show you options: linear, exponential, etc.line of best fit for scatter plot
  3. Select “linear” to get the fitted line for the points on your scatter plot.

That’s all. Now you have the line of best fit on your scatter plot.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.