This can be tricky because there are many elements of the chart you can click on and edit.
Begin by clicking once on any data point in your scatter plot. Now that you have a scatter plot in your Excel worksheet, you can now add your trend line. You should now have a scatter plot with your data represented in the chart. Then, click on the Insert tab on the Ribbon and locate the Charts section.Ĭlick on the button labeled Scatter and then select the button from the menu titled Scatter with Only Markers.
Suppose you have two columns of data in Excel and you want to insert a scatter plot to examine the relationship between the two variables.īegin by selecting the data in the two columns.
0 kommentar(er)
