Same Data - Different Graphs

Sometimes we can look at a lot of data .. and not know which chart/graph type to use!

Look at Mr. Widmer's data of the number of flies he counted on sunny summer afternoon.  Why did he do this? He had nothing else to do for 10 hours!

Same Data Varied Charts
Time Number of Flies
1 1
2 2
3 4
4 9
5 5
6 6
7 6
8 8
9 9
10 10
 

Question - What kind of graph/chart(in Excel) would clearly show the pattern of Mr. Widmer's observations?  You might like to see Mr. Widmer's attempt at making a chart in Excel.

This page was last updated on November 14th 2016 and part of the Mag-Net Maths Website