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..