I used this after an activity where we measured heights and arm lengths. This data can be entered into the spreadsheet, a scatter graph created and the line of best fit shown. Could be adapted for other variables.


  • Scatter graph data.xlsx
  • Scatter graph data (97-2003 workbook).xls

About this resource

Report a problem

This resource is designed for UK teachers. View US version .

1 Review

  • 3
    user avatarmcneillg6 years agoreport

    Useful time saver to demonstrate scatter graphs in Excel using simple, real data - or paste in data for your own class.