In National 4 Lifeskills Maths learn to graphically demonstrate the correlation between data sets and use a ‘line of best fit’ to further the given data.

3rd level Interpreting and describing data Line of best fit Data is presented in different ways across diagrams, charts and graphs.

If you need to create a Line Chart and Scatter Plot in Excel, read through this article. We have also explained which one is right for you.

You can make a line graph in Excel in a matter of seconds using data already entered into the spreadsheet.