I have a spreadsheet that I continually add data to. I have a chart
based on the data. My problem is I want the chart to only show the last
5 data points entered in the spreadsheet and continue to do so ass I
add more data.
Example Data:

LOT NUMBER DATA
1 13
2 12
3 14
4 12
5 13
6 15

As I add data I want the chart to show only the last 5 entries.
Is there a simple way to do this?