Moving data range in chart

[Peter]

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 *** 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 (in this
case lots 2-6).
Is there a simple way to do this?

[Miguel Zapico]

You can use a dynamic range as the source of the data. For example, if the
data is in Sheet1 on columns A and B, you can define a name
(Insert->Name->Define) that refers to:
=OFFSET(Sheet1!$A$1,COUNTA(Sheet1!$A:$A)-5,0,5,2)
And use the name as the source of the graph.

Hope this helps,
Miguel.

"Peter" wrote:

> 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 *** 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 (in this
> case lots 2-6).
> Is there a simple way to do this?
>
>