best+fit+line+on+graph



In Excel first you develop your data into an excel worksheet. You then go to the inset tab then under the chart ribbon and you choose scattered chart. Once you have chosen your scattered chart you go to the design tab at the top, then go to the data ribbon and click on 'select data'. You then select your data from your excel worksheet and it will automatically go into your chart. Once your chart has scattered points on it you right click on a point and select format trendline. Once you click on format trendline a menu (the menu above to the left) will come up. You then select trendline options and choose the type of trendline you would like. Since this is a best fit line, linear was chosen. The finished result looks like the graph in the middle.