I have created a named range 'Values' to select values for a chart using the following
If I press F5 and select Values the correct range is highlighted i.e. 12 columns to the left of the reference Admin!$B$4&62
If I try to use the formula in the Series Values I get the error 'That function isn't valid'
If I try to use the range name in the Series Values I get the generic 'The formula you typed contains an error' etc
Any ideas what I am missing?