在图表中使用的指定范围的偏移公式?

I am trying to use a (dynamic) named range as the source for my chart. I was hoping to be able to use 1 named range as the source for the chart, but so far, it is not working. I am trying to use a (dynamic) named range as t