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.

Some only have a scatter plot with all of the points while others show the line through the points. Choose the curved line graph unless another option is desired.

Here is a scatter plot showing a positive correlation between study time and test scores. The graph shows that the more one studies (X-axis), the higher one will score on a test (Y-axis).

If you wish to create a dynamic graph, you would have to use tables for the data. I hope it helps! Read: How to create a Line Chart and Scatter Plot Graph in Excel. How to calculate CPI in Excel?

The system is called Scatteract, and it’s the first system to extract data from the image of a scatter plot and represent it in the coordinate system of the chart in a fully automated way.