Named ranges as source data?

I am trying to use some named dynamic ranges as the source data on a line graph. For each series I have made a different range using =offset(etc.etc..).

Now if I try to use these named ranges as the values for a series on my line graph, I get the error "Not a valid function." Say the named range is "AnalyseSingData", in values I am typing =AnalyseSingData. If I define the same area manually by dragging the cells it all works fine. If I copy and paste the =Offset formula in to select the same cells as the dynamic range, I get the same "not valid function" message.

The reason I am doing it this way is that the size of the list of information goes up and down all the time.

Basically, is there a way of defining series values as a named range?

Thanks!

Andy

Hi Andy,

A series in a given chart canl accept a range name.
To make sure there is no confusion, in the series tab,

='MyWorkbook.xls'!YourRangeName

HTH
Carim

Thanks Carim! Fountain of Excel knowledge as always

Worked wonderfully

Thanks Andy ...
You are the King of kindness ...

Cheers
Carim