You need to calculate the number of columns to offset from the Anchor cell.
The Number of columns now becomes a static value, 12, rather than calculated.

CHTLABEL: =OFFSET(Sheet1!$B$22,0,COUNTIF(Sheet1!$B$23:$AZ$23,">=0")-12,1,12)

Not sure what the other data named ranges are suppose to be doing. Normally the simplest thing is to offset the CHTLABEL range.

CHTDATA1:
=OFFSET(CHTLABEL,1,0)

CHTDATA2:
=OFFSET(CHTLABEL,2,0)