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 .

Microsoft Excel 2013 enables you to add sets of data to a chart one at a time. If your data is in the proper order, however, you can plot both sets of data at the same time. Adding Data Sets One ...

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 .

One limitation of Excel is that it doesn't have a built in function to calculate the area between two curves. In order to calculate that area, you can use Excel's regression analysis function to ...