You would notice that the line graph and scatter plot chart curves are different. However, these charts are static. You could also consider creating Dynamic charts in Excel .

How to Make an X-Y Scatter Plot in Microsoft Excel. ... You can also add a line graph in Excel to connect data points rather than displaying them as single elements.

Excel has a method of adding a trend line to scatter data which gives R^2 - which measures the goodness of the fit. In addition excel has a method of fitting polynomials to the data and provides a ...

Launch the Excel 2010 spreadsheet that holds the scatter plot you want to adjust. Click anywhere on the chart, then click the "Layout" tab that appears at the top of the Excel window.