Dynamic offset // Name Field

Hi There,

I never faced this issue so a bit unsure how to work around it.. I've a bar chat where I use offset function to make it dynamic, it works fine but when I use the text in the field, it doesn't like and wondering if anybody knows how to make chart dynamic when my selection is "Text" Spreadsheet attached.. The Bar Chart "Chart Title " is how I want in dynamic calc. Any help is greatly appreciated..

any help is appreciated here guys.. All I'm trying to do is look for offset to go Row level except column level..

I'm positive I tried counta.. not sure why it didn't worked but now its working. Hate when excel makes you doubt your own work.. Thanks Champ!