Excel图表在添加新行时使用相同的范围

I am trying to get my Graph/Chart to recognize the new row that is added by a macro. For example, the chart's range is cells B2:F22 which works fine. However, when I run my macro, the macro inserts a new row above B2 and populates it with data. The chart however, changes to B3:F23 rather than staying with B2:F22 no matter what rows comes in. Any ideas on how to force it to stay with B2:F22? I tried doing $B:$F but that didnt work.I am trying to get my Graph/Chart to recognize