We will click on Chart Layout under the Charts tab, and select Trendline we can then select any desired trendline that match our scatter plot. We can format the chart to look as we desire using the tabs under Charts, for instance, adding titles to the axis and removing gridlines.įigure 4 – Under Charts, apply desired Formats and Layout optionsĪfter some formatting, we will have a chart like this before adding line of best fit excel įigure 5 – The Chart obtained after formatting before adding best fit line.We will select Scatter and then Marked Scatter or Bubble Scatter (depending on whether the computer is a MAC or Windows PC).įigure 3 – Select Scatter and Pick Marked Scatter. In our case, it is A2:B21.įigure 2 – Highlight the area with the data
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |