Hello -

I am trying to create a dynamic chart which auto updates as I add columns. I have used the OFFSET function in the past to update charts when I add rows but I am having trouble getting it to work for adding columns. In addition, I need the OFFSET to account for every other column (i.e. C, E, G, I, etc.)

I have named row 7:7 and it refers to =OFFSET('1464'!$C$7,0,COLUMN()*2-2,500)

'500' because columns will be added 2 per month for the foreseen future. Can you please tell me what I am doing wrong?

Thanks -