I am trying to use names to define the data and label ranges for my charts
but get an error message that my formula is incorrect. I have entered the
formula below and it works when not used in the chart tool. When I enter the
name in the chart tool I get an error message that my formula is incorrect.

I am using Excel 2007

CARLOW=OFFSET(SmallA!$B$119,0,0,'Calc Screen'!$Y$2,1)

--
mgelde