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 .

An X-Y scatter chart is an ideal plot choice when you have data sets with at least two interesting variables per record, and because scatter plots are a native graph option in Excel, you simply ...

How to Plot a Formula in Excel. ... When you click the "OK" button, Excel plots the chart for you and places it over your worksheet_. Drag or resize_ the chart as needed.

A scatter plot is just one style of chart-making in Excel. If you find that you need more flexibility in the presentation, you can right-click on the chart and select Change chart type .