Dynamic Chart Source Data

Hello,

I am pretty close, but I have something messed up in my name range, so my chart is wrong. My Data is listed in a worksheet, while my chart will be part of a mini dashboard on another worksheet. The top chart (chart!) is my attempt to create a dynamic source for the chart. The bottom chart is a simple example of what I am trying to do.

my name range:

=OFFSET(Data!$F$2,0,0,COUNTA(Data!$F:$F)+1,COUNTA(Data!$2:$2)+1)

Then I set my chart data source to:

=data!ChartTest

But, I am still getting the formulas listed in my chart.

I am not certain if I need to create an offset for each series (test score, average), then assign each series as the chart source data. In my reading, I have seen it both ways. The examples are always a bit different, so hard to know exactly what fits.

**After more reading, I think I might need to set up a name range for the data labels and each series (score and average). I can see my formula above is looking for both  the column and the rows, but I found many more examples on how to do it separately. Ideally, I would like to learn how to combine the function, so I can be more versatile in my approach. I totally get what I am trying to do,  but just missing something to make it click.

Thanks,
Brent
EE-dyanmic-chart-range.xlsm