OFFSET Function to Skip Rows

**wvualum** · 06-19-2012, 02:30 PM

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 -

**dilipandey** · 06-19-2012, 02:46 PM

Hi Wvualum,

Welcome to the forum.

Instead of 500 which is there for Width of Offset.. you can use counta function which will accomodate the future columns on the right side.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**wvualum** · 06-19-2012, 03:19 PM

Thanks! Anything as far as skipping every other row?

**dilipandey** · 06-20-2012, 01:08 PM

Hi Wvualum,

Upload a sample workbook with dummy data in case you have issues with this. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>