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:
- 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.
- Click on the plot to get “Chart Elements”. “Chart Elements” will have “Trendline”. Select that and it will show you options: linear, exponential, etc.
- 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.