Dynamic charting in Excel 2003

[Roberthorse]

Hi all, I would be grateful for help with the following.

I've got 4 chart lines on a chart.
On the spreadsheet the values are in 4 vertical columns A,B,C and D and there are 30 rows altogether.
The spreadsheet is set up so that variable numbers of rows contain numerical data. So any individual Column can have chart data in a variable number of rows [e.g. Row 1 to 10, Row to 1-26 etc] and there are never any empty rows between the 1st and last values listed in any Column.


But each chart line does not stop at the last value as I want it to...rather...it shows an unrecorded trend from the last value to zero.

Explanations of dynamic chart series formulae that I have found so far are not clear enough for me to understand. Can anybody help me?