I want to define a chart label and I have this:

=OFFSET(CPI_SPI_PITD!$B$33,0,0,1,MIN(CPI_SPI_PITD! CPI_SPI_PITD_chtlen,COUNTA(CPI_SPI_PITD!$33:$33)-1))

In row 33 of this sheet, I have the following Information
A33: CUM
B33: Jan 05
C33: Feb 05
D33: Mar 05 ...
M33:Dec 05

CPI_SPI_PITD_chtlen is defined as 12 for now
When I add data in column N, and view the named range that applies to this,
it still shows from B33: M33. Never moves to the right. What am I missing?

Thanks,
Barb Reinhardt