Hi

It depends upon how you want to display your chart, i.e all entries or just a subset.

If all entries then you can use the offset function for the chart ranges, e.g 

=OFFSET('(2)chartTable'!B1,1,0,COUNTA('(2)chartTable'!B:B)-1)
If for example the last 12 entries

=OFFSET('(2)chartTable'!B1,COUNTA('(2)chartTable'!B:B)-'(2)chartTable'!$A$1,0,12)
where A1 has the number of entries to be displayed.

Alternatively a slider bar could be used so that all entries could be displayed by dragging the slider.

Regards


Jeff