creating a named range taking the avg. to date of a dynamic range.

I have a column of data that keeps getting new information in it. what i need is a named range that i can use for a chart, first point in the named range will be the first value in the column, second point will be avg. of point 1 and 2, then 3rd point will be avg. of 1,2,3 etc.

Suggestion how to make this ?

got the help I needed on another thread i had

http://www.excelforum.com/excel-char...ml#post3767987