my chart is linked to data , so to make it dynamic, the chart is referencing named ranges ...the named ranges have the formula ="offset(A2,0,0,counta(A:A)-1,1)" for column A, then the same formulas for columns B , C, D, and E (ie. "offset(b2,0,0,counta(b:b)-1,1)", etc. etc.
i'm starting from A2 since row 1 has headers
but occassionally to keep the chart from not going too long, I will need to delete some rows starting from row 2
the problem is that if I delete row 2, it'll cause references errors for offset formula since they are referring to A2, B2, etc
is there a way around this?
i'm starting from A2 since row 1 has headers
but occassionally to keep the chart from not going too long, I will need to delete some rows starting from row 2
the problem is that if I delete row 2, it'll cause references errors for offset formula since they are referring to A2, B2, etc
is there a way around this?