Hi
I'm trying to use a cell reference value in the X Axis labels of Chart.
For example the static axis labels reference would be
=Student!$B$26:$R$26
However instead of it being $B$26, I need it to be $B with whatever Row number my named range "ColumnNumber" returns.
Many thanks
Ronan