create array of values returned by named formulas

Hi all,

Is it possible to used named formulas to build an array of values that
are not constants. I know you can use the myArray = {0,1,2,3} to
build an array of constants but can you simulate this effect with
named formulas, e.g. myArray = {myval1, myval2, mval3} where the
values are derived by named formulas, eg myval1 = average(some range).
I've tried using various syntax and the named range is 'accepted'
when entered into the define box but when i come to try and use the
name as a chart reference i get an error.

Thanks
Rob